vlookup to include text
Worked great, thank you.
"kassie" wrote:
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.
"Louise" wrote:
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
|