vlookup to include text

[Guest]

Hello

I wish to create a VLookUp which will return text when a match is found
rather than data from the lookup table. Can this be done?

Thank you.
Louise

 

[Guest]

This will return the text "My text" if a match is found (and blank if no match)

=IF(ISNA(VLOOKUP(C1,$A$1:$B$5,2,FALSE)),"","My text")

..... is this what is required?

 

[Guest]

You can return text whether a match is found or not. For example
=IF(ISNA(VLOOKUP(D1,$A$1:$C$15,2,FALSE)),"No Match", "Match"), will return
the words No Match, if no match is found, and Match if a match is found.

 

[Guest]

Excellent, thank you.
Louise

This will return the text "My text" if a match is found (and blank if no match)

=IF(ISNA(VLOOKUP(C1,$A$1:$B$5,2,FALSE)),"","My text")

.... is this what is required?

 

[Guest]

Worked great, thank you.
Louise

This will return the text "My text" if a match is found (and blank if no match)

=IF(ISNA(VLOOKUP(C1,$A$1:$B$5,2,FALSE)),"","My text")

.... is this what is required?

 

[Guest]

Worked great, thank you.

You can return text whether a match is found or not. For example
=IF(ISNA(VLOOKUP(D1,$A$1:$C$15,2,FALSE)),"No Match", "Match"), will return
the words No Match, if no match is found, and Match if a match is found.

 

[Guest]

Works a treat. Just out of interest, what does ISNA mean??
Louise

 

[Guest]

Take a look at the "Information" functions:

ISNA Value refers to the #N/A (value not available) error value.

Simply, the value (match) cannot be found.