Using words in Formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lanza52 - 20 Aug 2006 02:38 GMT

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

Reply to this Message

Ron Coderre - 20 Aug 2006 03:20 GMT

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

> I need to use VLookup with a word in the middle linked from another
> cell.
[quoted text clipped - 10 lines]
>
> Anybody know how to link that?

Reply to this Message

Lanza52 - 20 Aug 2006 04:25 GMT

Yes, it works.

Much thanks. :

Reply to this Message