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
|