Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup considering 2 conditions
Dear Friends,
I want to match a table with comnponents, customer name, value with another table where there are the components and the customers' names. the output on the first table is a flag - like 1 or yes or whatever- when the match is found. the difficulty for me is the double condition -matching of components + customer names- . Another one , but as second priority, is that sometimes the customer names can be sligtly different in the 2 tables, so difficult to match....The components' names are absolutely the same in the 2 tables . Any idea? thanks in advance. -- Enrico Mandelli |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup considering 2 conditions
Try additional column.
Components = A Customers = B Use a formula: C1 = A1&" "&B1 This will make your record unique. -- HTH Topola |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup considering 2 conditions
=IF(ISNUMBER(MATCH(A1&A2,Sheet2!$A$1:$A$200&$B$1:$ B$200,0)),1,0)
which is an array formula, so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct) "emandell" wrote in message ... Dear Friends, I want to match a table with comnponents, customer name, value with another table where there are the components and the customers' names. the output on the first table is a flag - like 1 or yes or whatever- when the match is found. the difficulty for me is the double condition -matching of components + customer names- . Another one , but as second priority, is that sometimes the customer names can be sligtly different in the 2 tables, so difficult to match....The components' names are absolutely the same in the 2 tables . Any idea? thanks in advance. -- Enrico Mandelli |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you do a VLookup with two conditions? | Excel Worksheet Functions | |||
Vlookup using 2 conditions | Excel Discussion (Misc queries) | |||
How:iserror vlookup & count no. times value shows with conditions | Excel Worksheet Functions | |||
VLOOKUP with multiple conditions | Excel Discussion (Misc queries) | |||
Vlookup with multiple conditions | Excel Worksheet Functions |