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.