VLOOKUP and ISTEXT

  • Thread starter Thread starter Matt Houston
  • Start date Start date
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
 
Here's a simple one that works (without Concatenation):

=IF(ISTEXT(VLOOKUP(A10,My_Table,3,FALSE)),"You Got TEXT","Its Not Text")
 
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.
 
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
 
Back
Top