Forum Discussion
Solved
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...
=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.