Auto fill in other ballots when importing data

%3CLINGO-SUB%20id%3D%22lingo-sub-2817299%22%20slang%3D%22en-US%22%3EAuto%20fill%20in%20other%20ballots%20when%20importing%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2817299%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everybody.%3C%2FP%3E%3CP%3EI%20use%20Excel%20web%2C%20through%20the%20Windows%20computer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20spreadsheets%2C%20one%20to%20register%20(Sheet%20A)%20and%20the%20other%20with%20a%20list%20of%20products%20(Sheet%20B)%2C%20which%20contains%20some%20information%20together.%3C%2FP%3E%3CP%3EI%20want%20to%20type%20the%20code%20on%20Sheet%20A%2C%20and%20importing%20the%20data%20from%20Sheet%20B%2C%20the%20ballots%20complete%20themselves%20on%20Sheet%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20Worksheet%20A%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22alexsandrop_silva_1-1633521884282.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315576i2BA5E65BCABC8246%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22alexsandrop_silva_1-1633521884282.png%22%20alt%3D%22alexsandrop_silva_1-1633521884282.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20Worksheet%20B%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22alexsandrop_silva_0-1633521815391.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315575i37D652B8F8DB1358%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22alexsandrop_silva_0-1633521815391.png%22%20alt%3D%22alexsandrop_silva_0-1633521815391.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3EIf%20I%20type%20code%20680%20on%20Sheet%20A%2C%20I%20want%20it%20to%20auto-complete%20SheetA%20-%26gt%3B%20A2%20and%20SheetA%20-%26gt%3B%20A7.%20The%20data%20to%20fill%20in%20these%20ballots%20will%20be%20on%20Worksheet%20B.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2817299%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2817810%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20fill%20in%20other%20ballots%20when%20importing%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2817810%22%20slang%3D%22en-US%22%3EWhen%20you%20say%20you%20have%202%20worksheets%20are%20you%20really%20saying%20you%20have%202%20workbooks%20or%201%20workbook%20with%202%20worksheets%3F%20If%20it%20is%20the%20former%20(2%20workbooks)%20I%20would%20suggest%20you%20move%20the%20other%20workbook%20sheet%20into%20the%20same%20workbook.%3CBR%20%2F%3EThat%20said%2C%20all%20you%20need%20is%20to%20use%20a%20formula%20like%3A%3CBR%20%2F%3E%3DVLOOKUP(A2%2C%20Range_on_sheet_B%2C%20Col_to_return%2C%20False)%3CBR%20%2F%3Eso%20may%20look%20like%3A%3CBR%20%2F%3E%3DVLOOKUP(A2%2C%20'Worksheet%20B'!A1%3AC20%2C%202%2C%20False)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everybody.

I use Excel web, through the Windows computer.

 

I have two spreadsheets, one to register (Sheet A) and the other with a list of products (Sheet B), which contains some information together.

I want to type the code on Sheet A, and importing the data from Sheet B, the ballots complete themselves on Sheet A.

 

Here's Worksheet A:

alexsandrop_silva_1-1633521884282.png

 

Here's Worksheet B:

alexsandrop_silva_0-1633521815391.png

 

Example:

If I type code 680 on Sheet A, I want it to auto-complete SheetA -> A2 and SheetA -> A7. The data to fill in these ballots will be on Worksheet B.

1 Reply
When you say you have 2 worksheets are you really saying you have 2 workbooks or 1 workbook with 2 worksheets? If it is the former (2 workbooks) I would suggest you move the other workbook sheet into the same workbook.
That said, all you need is to use a formula like:
=VLOOKUP(A2, Range_on_sheet_B, Col_to_return, False)
so may look like:
=VLOOKUP(A2, 'Worksheet B'!A1:C20, 2, False)