VLOOKUP and ISTEXT

M

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
 
J

JMay

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

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

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.
 
M

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
 
Top