Forum Discussion

Copper Contributor

Feb 01, 2022

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 #). ...

excel

Formulas and Functions

HansVogelaar

MVP

Feb 01, 2022

SuzanneP

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),"")