Using words in Formulas

L

Lanza52

I need to use VLookup with a word in the middle linked from anothe
cell.

IE:

VLOOKUP(A5,(A word from Cell E17),2,FALSE)

E17 varies from the results of 2 other cells. But its a word. E17 i
=C4&""&C5. In this case it is "FirstStats."

So it would be:
VLOOKUP(A5,FirstStats,2,FALSE)

Anybody know how to link that
 
R

Ron Coderre

Since it wouldn't be possible to VLOOKUP a word in another word and return
the value from the second column of that word as your formula indicates:
VLOOKUP(A5,(A word from Cell E17),2,FALSE)

So, I'm guessing that the "word from Cell E17" indicates a named range.
If that's true, try this:

VLOOKUP(A5,INDIRECT(E17),2,FALSE)

The INDIRECT function will make Excel treat the value of E17 as if it
references a range.

Am I on the right track here?
Does that help?

***********
Regards,
Ron

XL2002, WinXP
 
Top