View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
emandell
 
Posts: n/a
Default 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