| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup to include text
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup to include text
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? "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup to include text
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup to include text
Excellent, thank you.
Louise "Toppers" wrote: 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? "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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup to include text
Worked great, thank you.
Louise "Toppers" wrote: 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? "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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup to include text
Works a treat. Just out of interest, what does ISNA mean??
Louise "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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup to include text
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. "Louise" wrote: Works a treat. Just out of interest, what does ISNA mean?? Louise "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wrapping text and vlookup | Excel Worksheet Functions | |||
| Vlookup text conversion issue | Excel Discussion (Misc queries) | |||
| Vlookup where text not exact | Excel Discussion (Misc queries) | |||
| Return a text string when the result of VLOOKUP formula is #N/A | Excel Worksheet Functions | |||
| VLOOKUP first numerical value (not text) | Excel Worksheet Functions | |||
Linear Mode
