I am using vlookup to access data in other spreadsheets. The spreadsheet to
access varies by the data being searched for. I am trying to use a cell
reference for the table_array value to make things easier. Something like:
=IF($B25<"",VLOOKUP(B25,B7,2,FALSE),"") where the path name is stored in B7.
Any suggestions?