VLookup return a value if any text is in the target cell

[MalR]

Hi guys. I can't seem to find an answer on this. I need a VLookup formula so that if any text at all is in the target cell it will return the word Reg.
Could you help me with this please?
Thanks
Mal

 

[NARAYANK991]

Hi Mal ,

You do not need a VLOOKUP for this ; if you are saying that the logic is :

If target cell has any text , then return the word Reg , else ?

then a simple IF formula will suffice , though you will need to make use of the ISTEXT function.

If the target cell is A1 , then :

=IF(ISTEXT(A1) , "Reg" , "No text")

should be enough.

Narayan

 

[MalR]

Hi Mal ,

You do not need a VLOOKUP for this ; if you are saying that the logic is :

If target cell has any text , then return the word Reg , else ?

then a simple IF formula will suffice , though you will need to make use of the ISTEXT function.

If the target cell is A1 , then :

=IF(ISTEXT(A1) , "Reg" , "No text")

should be enough.

Narayan

Thanks Narayan. Exactly what I wanted. I was not aware of ISTEXT. You guys are most helpful!
MalR