New to Excel should be simple but i am not getting it

[Ichigo282]

I have 2 sheets Sheet1 and Sheet2 on a spreadsheet.  Column A in both spreadsheets have names.  Column F on sheet1 has an amount associated to the persons name on Sheet 1 Column A.  I want to display on Sheet2 in column B the number from Sheet1 Column F of the person in column A on sheet 2 if the name on Sheet 1 and Sheet 2 match.

[#2 · Accepted solution]

@Ichigo282 

=IFERROR(VLOOKUP(A2,Sheet1!$A$2:$F$13,6,FALSE),"")

You can try this formula. An alternative could be INDEX and MATCH. If you work with Excel 2016 or later you can apply XLOOKUP.

[#3]

Thank you for the quick response. I found the VLOOKUP and was playing with it and seems i was close. This worked perfect.