VLOOKUP Help

%3CLINGO-SUB%20id%3D%22lingo-sub-3098989%22%20slang%3D%22en-US%22%3EVLOOKUP%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3098989%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20shouldn't%20be%20this%20hard.%20I'm%20working%20in%20Excel%202013%3C%2FP%3E%3CP%3EI%20want%20to%20return%20values%20to%20fill%20in%20contact%20information%20from%20a%20different%20spreadsheet%20file%20(or%20even%20a%20tab)%20based%20on%20a%20record%20number%20(RGA%20%23).%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Excel%20Crop.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344172i8355A32699638F44%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Excel%20Crop.png%22%20alt%3D%22Excel%20Crop.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Form%20Crop.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F344173i053728A82351205B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Form%20Crop.png%22%20alt%3D%22Form%20Crop.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3098989%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3099737%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3099737%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1293524%22%20target%3D%22_blank%22%3E%40SuzanneP%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20C5%20on%20the%20Invoice%20sheet%3A%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(B2%2C'2022'!A%3AG%2C2%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3EIn%20C6%3A%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(B2%2C'2022'!A%3AG%2C5%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3EIn%20C7%3A%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(B2%2C'2022'!A%3AG%2C7%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3EIn%20C8%3A%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(B2%2C'2022'!A%3AG%2C3%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3EIn%20C9%3A%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(B2%2C'2022'!A%3AG%2C4%2CFALSE)%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 Crop.pngForm Crop.png

 

1 Reply

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