Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookups
I am trying to compare 2 different listings to see if any in list 1 is a
client. My lookup will only return the client if the client is an exact match. How can I make the lookup return any variation of the name This is my normal lookup: =IF(ISERROR(VLOOKUP(A1,'clients'!$A$1:$B$200,2,FAL SE)),0,VLOOKUP(A1,'clients'!$A$1:$B$200,2,FALSE)) Example Sheet 1 - (Possible Client Names) Column A ABC Co Sheet 2 - (our client names) Column A Col B The ABC Company 1000 So I want to look up the name in sheet 1 and return the possible match from sheet 2. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookups | Excel Worksheet Functions | |||
Lookups or something | Excel Worksheet Functions | |||
Maybe I need help with Lookups?? | Excel Worksheet Functions | |||
Lookups | Excel Worksheet Functions | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |