Comparing two columns, and returning values in the 4th column from the 3rd column

the file uploaded above contains many data than the one i showed above in the pics. my concern is the checks sheet. 2 columns of concern A and F in the accounts sheet.

Checks sheet column AA is the same as A above with values unevenly dispersed. Yes the are the same if you scroll down you may find very few data similar. actually i exported just 100 transactions to excel from quickbooks so i think thats y this issue.

anyhow i want to fill in column Y of Checks with values of column F of Accounts but with respect to column AA of Checks which will be matched (i think) to Column A of Accounts.

thanx newdoverman.

this is exactly what i want.

can you provide me the formula without clicking the cells or columns. eg. instead of showing table1ID, rather show like $A$2:$A$10.

you can provide me the formula for your own worksheet.

i tried it myself but its not working that way so thats y i ask.

one more thing if drag the last cell W10 further down will it automatically fill in the 4 digit codes (given that there is data entered in columns U and V beyond row10)