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

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

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