Home

VLOOKUP, 2 excel documents

%3CLINGO-SUB%20id%3D%22lingo-sub-664674%22%20slang%3D%22en-US%22%3EVLOOKUP%2C%202%20excel%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664674%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20working%20with%202%20excel%20documents%20(I%20have%20recreated%20them%20in%20simple%20form%20below)%2C%20'spreadsheet%201'%20was%20supplied%20to%20me%20and%20'spreadsheet%202'%20is%20what%20I%20update%20with%20my%20findings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20the%20length%20in%20'spreadsheet%202'%20(Column%20AT)%20to%20automatically%20update%20with%20the%20correct%20length%20(from%20'spreadsheet%201'%2C%20'Column%20Q')%20when%20I%20input%20the%20%22Unique%20ID%22%20into%20'spreadsheet%202'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20I%20would%20like%20this%20length%20to%20automatically%20double%20in%20'spreadsheet%202'%20if%20the%20'Type'%20in%20'Column%20F'%20reads%20'Fillet'.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EPlease%20note%20it%20is%20not%20possible%20to%20merge%20the%202%20excel%20spreadsheets!%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116978iBC6094F67C3483BD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Example%20spreadsheet%201.png%22%20title%3D%22Example%20spreadsheet%201.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116977i82C5FECB40B12204%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Example%20spreadsheet%202.png%22%20title%3D%22Example%20spreadsheet%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-664674%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-664678%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%2C%202%20excel%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-664678%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20attached%20the%202%20excel%20documents%20in%20question%3C%2FP%3E%3C%2FLINGO-BODY%3E
AdamPalmer
New Contributor

I am currently working with 2 excel documents (I have recreated them in simple form below), 'spreadsheet 1' was supplied to me and 'spreadsheet 2' is what I update with my findings.

 

I would like the length in 'spreadsheet 2' (Column AT) to automatically update with the correct length (from 'spreadsheet 1', 'Column Q') when I input the "Unique ID" into 'spreadsheet 2'.

 

Also, I would like this length to automatically double in 'spreadsheet 2' if the 'Type' in 'Column F' reads 'Fillet'.

 

Please note it is not possible to merge the 2 excel spreadsheets!

 

Example spreadsheet 1.pngExample spreadsheet 2.png

1 Reply

I have attached the 2 excel documents in question