Using Variables in Vlookups.
Posted by Lael Buchanan on December 11, 1999 10:14 AM
Got a good one for anyone that can help. I have a Vlookup that I need to do where the table that it is looking on varies depending on another variable. So my lookup loks something like this:
I've tried to use a nested Vlookup to find the right table, but that didn't seem to work as all I got was a #Value error. Can anyone give me any information on hwo to get a variable to work withing a vlookup?
Thanks in advance,