How to look up info in other tab - based on ID listed in Column (EXAMPLE FILE ATTACHED)

Hello,

I am looking for a function that will allow me to look up, and insert information into a column from another tab in my sheet.

Specifically, I have two sheets - both with an Account ID in Column A, listing different information. What I want to find, is a function that will allow me to look at the Account ID in column A of Sheet 1, search that same account ID in Column A of sheet 2, and, if the account ID exists in the second sheet, list the number in column C, of sheet 2.

E.g (attached) the first sheet has three columns - one with the account ID, one with account type and one with Year. The second sheet also has three columns - one with account ID, one with account type and one with Amount. What I am looking for, is a way of transferring the Amount column from the second to the first sheet, matching it with the accound ID if it exists on both sheets - and leave it blank if it only exists on sheet 1.

I have tried with Vlookup and Hlookup, but I am not sure what I am doing wrong. Any help would be appreciated!

Thanks.

Hi FDibbins,

Thank you!

It seems to work for the first row, but copies the information for all other rows. Is there a way to alter the formula so I can drag it down for all rows?

Thanks.

Perfect - thank you!