Hi all,

I have two identical column in sheet 1 & sheet 2, I intend to compare both column and find the result of the value into sheet 1. Using vlookup can only search for one column. I look thru other site on net, it said needs to use both index & match function. But I am bit confuse and find no where how to go about. Please help me.

my data in sheet 1
Partno________JOB_______Qty
PART1________JOBA______1
PART2________JOBB______22
PART1________JOBC______5

compare to data in sheet 2
Partno________JOB_______Qty
PART1________JOBA______5
PART2________JOBK______11
PART1________JOBC______5
PART2________JOBM______4

I intend to compare both sheet and take the result of qty column in sheet 2 to sheet 1.

Thanks.

Lim