VLOOKUP Help

[SuzanneP]

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

[#2]

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