Stuck with VBA formual to copy data from another sheet with mutiple criteria

[topnotchthrillr]

Hi,

In sheet 1, "Type of currency" is entered in row 6, columns 3 to 143. "Account number" entered in column 1, rows 10 to 383.

In sheet 2, "Type of currency" is entered in column 3, rows 2 to 1044. "Account number" entered in column 2, row 2 to 1044.

in Sheet 2, the amount is entered in column 7, rows 2 to 1044.

I am trying code a vba to look match the "type of currency" and "account number" in sheet 1 with the "type of currency" and "account number" sheet 2 and return the amount from sheet 2 to sheet 1.

I am able to do it with a for loop formual if there is only i criteria but with 2 I am confused how to accomplish this.

Any help would be greatly appreciated. If you need me to upload the file, I can do that.

[Kaper]

show us what you did with one criteria.
Basically - in this approach you shall probably use two loops.