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