ssafiri
12-05-2010, 01:02 AM
Hi all,
How can I VLOOKUP on two column that their value are matched?
As in attached file I want to extract values in Sheet PS that their column PS and SB match each other. I mean when there is double item in column A(PS) it doesnt return related value in matched raw.Here in sheet 1 under PS21 i want to have
PS 21
21000
31000
6600
instead of XX.:dunno
thanks
How can I VLOOKUP on two column that their value are matched?
As in attached file I want to extract values in Sheet PS that their column PS and SB match each other. I mean when there is double item in column A(PS) it doesnt return related value in matched raw.Here in sheet 1 under PS21 i want to have
PS 21
21000
31000
6600
instead of XX.:dunno
thanks