Forum Discussion
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...
WaterRob See: https://www.contextures.com/exceldatavaldependindextablesindirect.html
There are several methods detailed there, so pick which one works best for you.
HTH
- Thank you for your response! That link did the trick! Now need to have the Indirect Function not include the blank spaces in then end.
