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