Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
VLOOKUP supports wildcards, so if you replace $A3 with "*"&$A3&"*" you have "contains" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sarah (OGI)" wrote: I've got the following formula: =IF(VLOOKUP($A3,Lookup!$A:$K,9,FALSE))=16,"Yes","N o") However, I'd like the formula to now see if the result of the vlookup contains (not equals) a particular value, i.e. if the returned value contains '16', I want to show "Yes", otherwise "No". A vlookup might not even be the right function for this, so any help would be appreciated. Many thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
How identify data of two coulams,Every cell count and show result | Excel Discussion (Misc queries) |