Need Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2789381%22%20slang%3D%22en-US%22%3ENeed%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2789381%22%20slang%3D%22en-US%22%3EI%20work%20as%20a%20project%20manager%20for%20a%20construction%20company%2C%20and%20just%20started%20using%20Excel%20to%20keep%20track%20of%20payments%20to%20our%20vendors%2Fsubs.%20In%20our%20system%2C%20each%20vendor%20has%20a%20designated%205%20numeric%20code%20(ex%3A%20T%26amp%3BC%20Tile%20Installation%20is%20%2316204).%20Is%20there%20a%20way%20I%20can%20type%2016204%20in%20one%20cell%2C%20and%20set%20it%20to%20auto%20fill%20their%20company%20name%20in%20the%20next%20cell%2C%20their%20owners%20information%20in%20the%20following%20cell%2C%20etc.%20Hope%20that%20makes%20sense!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2789381%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2789448%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2789448%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1168066%22%20target%3D%22_blank%22%3E%40Chuck1996%3C%2FA%3E%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20have%20a%20list%20of%20vendor%20codes%20with%20related%20information%20on%20a%20sheet%20named%20Vendors%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0790.png%22%20style%3D%22width%3A%20503px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F313166iF953A00557956952%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0790.png%22%20alt%3D%22S0790.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EOn%20your%20payment%20sheet%2C%20you%20enter%20the%20vendor%20code%20in%20for%20example%20D2%20and%20down.%3C%2FP%3E%0A%3CP%3EIn%20E2%2C%20enter%20the%20formula%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(D2%2CVendors!%24A%242%3A%24Z%24100%2C2%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3EIn%20F2%2C%20that%20would%20be%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(D2%2CVendors!%24A%242%3A%24Z%24100%2C3%2CFALSE)%2C%22%22)%3C%2FP%3E%0A%3CP%3Eetc.%3C%2FP%3E%0A%3CP%3EAdjust%20the%20range%20if%20necessary%20-%20it%20doesn't%20matter%20if%20it%20is%20larger%20than%20your%20actual%20vendors%20list.%3C%2FP%3E%0A%3CP%3EYou%20can%20copy%2Ffill%20the%20formulas%20down%20as%20far%20as%20you%20want.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I work as a project manager for a construction company, and just started using Excel to keep track of payments to our vendors/subs. In our system, each vendor has a designated 5 numeric code (ex: T&C Tile Installation is #16204). Is there a way I can type 16204 in one cell, and set it to auto fill their company name in the next cell, their owners information in the following cell, etc. Hope that makes sense!
1 Reply

@Chuck1996

Let's say you have a list of vendor codes with related information on a sheet named Vendors:

S0790.png

On your payment sheet, you enter the vendor code in for example D2 and down.

In E2, enter the formula

=IFERROR(VLOOKUP(D2,Vendors!$A$2:$Z$100,2,FALSE),"")

In F2, that would be

=IFERROR(VLOOKUP(D2,Vendors!$A$2:$Z$100,3,FALSE),"")

etc.

Adjust the range if necessary - it doesn't matter if it is larger than your actual vendors list.

You can copy/fill the formulas down as far as you want.