MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel vlookup arrays


Posted by Nick on January 09, 2001 9:52 PM

When I use the vlookup function, how do I use the contents of a cell (eg. "array") to specify the array/table to look in? I think I need to let excel know that I want to use the text in that cell but I'm having trouble doing so. Please help.

Thanks
Nick


Posted by Aladin Akyurek on January 09, 2001 10:03 PM

Just curious about the formula that you (attempt) to use. Care to place it here, if even half-baken?

Posted by Dave Hawley on January 09, 2001 10:57 PM

(attempt) to use. Care to place it here, if even
half-baken?


Hi Nick

You need to use the INDIRECT function for this like below:
VLOOKUP("abc",INDIRECT(F1),2)


Where F1 contains the range to look in.

Dave


OzGrid Business Applications

Posted by Nick on January 10, 2001 2:46 PM

Thanks, Dave.