Matching values from Sheet1, returning value from Sheet2

[Guest]

I need a formula where on Sheet1 cells A10 and K3 have a value entered. I would like to look up the matching value on Sheet2, column A & B, then return the value from Sheet2 column C to Sheet1 cell D10.

Appreciate any feedback.

 

[Derek]

Hi
I assume you mean this:
Look down column A in sheet2 to find the value equal to A10 (where the value next to it in column B is equal to K3), then return the value in column C.
You could try this formula in Sheet1 D10
=INDIRECT("Sheet2!C"&MATCH(A10&K3,Sheet2!D:D,0))

This requires use of a hidden column in Sheet2. I have used column D:D
Insert this formula in D1 and scroll down =A1&B1

Hope this helps
Regards
Derek