I need to use VLookup with a word in the middle linked from another
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 is
=C4&""&C5. In this case it is "FirstStats."

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

Anybody know how to link that?


--
Lanza52
------------------------------------------------------------------------
Lanza52's Profile: http://www.excelforum.com/member.php...o&userid=36316
View this thread: http://www.excelforum.com/showthread...hreadid=573485

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


"Lanza52" wrote:


I need to use VLookup with a word in the middle linked from another
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 is
=C4&""&C5. In this case it is "FirstStats."

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

Anybody know how to link that?


--
Lanza52
------------------------------------------------------------------------
Lanza52's Profile: http://www.excelforum.com/member.php...o&userid=36316
View this thread: http://www.excelforum.com/showthread...hreadid=573485

Yes, it works.

Much thanks. :)


--
Lanza52
------------------------------------------------------------------------
Lanza52's Profile: http://www.excelforum.com/member.php...o&userid=36316
View this thread: http://www.excelforum.com/showthread...hreadid=573485