Forum Discussion
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.
=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.
=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.
- Thank you for the quick response. I found the VLOOKUP and was playing with it and seems i was close. This worked perfect.
