Vlookup considering 2 conditions

E

emandell

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.
 
T

topola

Try additional column.
Components = A
Customers = B

Use a formula:
C1 = A1&" "&B1

This will make your record unique.
 
B

Bob Phillips

=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)
 
Top