Forum Discussion

Copper Contributor

Nov 12, 2019

Data Validation and VLookUp issues

I have worksheet with a data validation list. This list is dynamic and is working fine: =OFFSET('Sheet List'!$BL$1,1,0,MAX('Sheet List'!$BK:$BK),1) Once you select an item from the list above I...

excel

Formulas and Functions

Twifoo

Silver Contributor

Nov 13, 2019

WaterRob

To obtain help easier, please attach your sample Excel file.

WaterRob
Copper Contributor
Nov 13, 2019
Thank you for your reply, I was able to figure out using Indirect Function. Now just need to exclude the blanks at the end of the Validation List.
- Twifoo
  Silver Contributor
  Nov 13, 2019
  Being volatile, INDIRECT is indubitably NOT the best function for you to use. Though I must congratulate you for seeing some light in the link provided to you, such light is insufficient to guide you through your desired outcome, unless you attach your sample file!