Hi Dear, try the below formula in Sheet1 D2.

Please note that the below is a array formula. In cell D2 press function key
F2 to edit and paste the formula. Please make sure the formula goes into one
line. Press Ctrl+Shift+Enter to apply this formula. Once done you can notice
the curly braces in the formula bar. Please try and feedback

=INDEX(Sheet2!C2:C20,MATCH(A2&B2,Sheet2!$A$2:$A$20 &Sheet2!$B$2:$B$20,0),1)


If this post helps click Yes
---------------
Jacob Skaria


"Vandmic" wrote:

i'm new to excel & what i'm trying to do is; lookup two cells (A2:B2) in
sheet1 & find the matching data in sheet2 (A2:B20) and return the data in
column "D"

Sheet 1
answer
A B C D
103539 1000800796 2 37500042
103539 1000800797 3
103539 1002055700 4
103539 1000800793 5
103539 1001331388 6
103539 1000926809 7
103539 1002521267 1
103539 1000762584 1
103539 1000762551 2
103539 1000992028 3
103539 1000401463 1

Sheet 2
A B C
103539 1001904703 42500042
103539 1000800796 37500042
103539 1000800797 57500042
103539 1002055700 77500042
103539 1000800793 27500042
103539 1001331388 67500042
103539 1000926809 87500042