Thread: Looking Up A Value In A Name Range

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)

An Exceltip.com email (spam?) directs on to a page
http://www.exceltip.com/st/Looking_U...Range/878.html
Which shows a wrong formula
=VLOOKUP(B2,INDIRECT(C2),1,FALSE),1,FALSE)
compared to the formula in this topic
=VLOOKUP(B2,INDIRECT(C2),1,FALSE)
Also, it shows column A but doesn't show what's in columns B and C.