Matching Problem

[chandan12]

I have used "Match" function to match the Check number of two sheets as given in attachment. After that I want to match the amount and the amount will be matched only if the check number is matched. I want to say first the check number will be matched then the amount.

I am trying to match check number in Column E in Bank sheet.

How I can do this?

May I use "offset" function.

[martindwilson]

use index
=INDEX(Ledger!$C$2:$C$2000,MATCH(B2,Ledger!$A$2:$A$2000,0))

[chandan12]

Thanks martindwilson, my problem has solved.