Forum Discussion
VLOOKUP Help
This shouldn't be this hard. I'm working in Excel 2013
I want to return values to fill in contact information from a different spreadsheet file (or even a tab) based on a record number (RGA #).
1 Reply
In C5 on the Invoice sheet:
=IFERROR(VLOOKUP(B2,'2022'!A:G,2,FALSE),"")
In C6:
=IFERROR(VLOOKUP(B2,'2022'!A:G,5,FALSE),"")
In C7:
=IFERROR(VLOOKUP(B2,'2022'!A:G,7,FALSE),"")
In C8:
=IFERROR(VLOOKUP(B2,'2022'!A:G,3,FALSE),"")
In C9:
=IFERROR(VLOOKUP(B2,'2022'!A:G,4,FALSE),"")
