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

New Contributor

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 Replies
best response confirmed by Ichigo282 (New Contributor)



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


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