Find Match of 2 Columns, Between 2 Worksheets

Hi

I am trying show an exact match of data between two worksheets, but I need the match function to look up 2 columns - i.e. reference number AND order number between two different worksheets.

In the example attached, I am able to find the match of one column only (order number), can anyone help me on this?

Thanks

Hi Saranag

I was trying to use the vlookup function but couldn't quiet get it to work.

Are you able to help/guide?

Thanks

Originally Posted by hemesh

Try below in Sheet Data2 A2
copy paste below then hold control and shift together and Hit enter
=IF(ISNUMBER(MATCH($B2&$C2,Data1!$A$2:$A$7&Data1!$B$2:$B$7,0)),"Found","Not Found")

Hi hemesh

This works great, thank you for your input! However, is there are way of avoiding to 'hold control and shift together and hit enter'? I may have 100s of records and this may take a while if I have to do this each time.

Thanks

Originally Posted by hemesh

No you don't need to put control shift and enter every time. When you enter the formula in first cell , In the right hand side bottom corner of cell you will find a square, hover your cursor over the square and your cursor will change to "+" sign then press right mouse button to hold this and drag it down till you have data in the cells Or double click "+" sign

check below Link
http://www.youtube.com/watch?v=zcA9MMskIRg

Many thanks, hemesh!

This worked for me both ways!