Thread: Using words in Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lanza52 Lanza52 is offline
external usenet poster
  
Posts: 1
Default Using words in Formulas

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

Reply With QuoteReply With Quote