SOLVED

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

Copper Contributor

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

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 (Copper Contributor)
Solution

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

``=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.

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

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

Accepted Solutions
best response confirmed by Ichigo282 (Copper Contributor)
Solution

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

``=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.