Problem:
First3 and Last3 are the names defining ranges A2:A4 and A5:A7 accordingly.
How could we create a formula that will look up each of the values listed in column B in the Name range?
Solution:
Using the INDIRECT function, in the following VLOOKUP formula:
=VLOOKUP(B2,INDIRECT(C2),1,FALSE)
Bookmarks