VLOOKUP and ISTEXT

[Matt Houston]

Hey, i need to check that each cell in the range im doing my lookup in
contains text, how would i do that?

here is my function:

=VLOOKUP($A3&$B3&D$1,Multiples2!$E2:$F10001, 2, FALSE)

any ideas? Ive tried to say IF(ISTEXT(Multiples2!$E2:$F10001), but that
just causes more complications. thanks

 

[JMay]

Here's a simple one that works (without Concatenation):

=IF(ISTEXT(VLOOKUP(A10,My_Table,3,FALSE)),"You Got TEXT","Its Not Text")

 

[Matt Houston]

hey thanks thats good. only thing is that now i have "this is text" in
the cell instead of the inforamtion i looked up. it needs to check that
it is text, if so place the text in the cell, else leave it blank.

 

[Max]

Using your VLOOKUP given and along the lines suggested by JMay,

Try :

=IF(ISTEXT(VLOOKUP($A3&$B3&D$1,Multiples2!$E$2:$F$10001,2,FALSE)),VLOOKUP($A
3&$B3&D$1,Multiples2!$E$2:$F$10001,2,FALSE),"")

Note that I've fixed your table_array "Multiples2!$E$2:$F$10001"
ie made it absolute refs,
just in case you're copying the formula down the column

 

[Matt Houston]

works great, thanks guys!

 

[Max]

Matt, you're welcome !
Thanks for the feedback.

cheers
Max