View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harutoni Harutoni is offline
external usenet poster
 
Posts: 1
Default how to do matching 2 criterias

Dear Sir,

I need help to match 2 column ranges, how is that possible with excel
worksheet.
I tried with INDEX and MATCH but only can do with 1 range

example:
column 1 brand of vehicles (chevrolet, toyota, renault. etc)
column 2 type of car (1000cc, 1300cc, 2000cc, etc)
then say I need to match the price of these vehicles in other worksheet that
the list is not in the same order

Best Regards,
Harutoni