Help Merging Spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3011854%22%20slang%3D%22en-US%22%3EHelp%20Merging%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011854%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20if%20someone%20is%20able%20to%20help%20it%20would%20be%20greatly%20appreciated!%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%201%20excel%20spreadsheet%20which%20has%20over%203%2C000%20products%3B%20providing%20general%20product%20information%20such%20as%20colour%2C%20material%2C%20descriptions%20images%20and%20sizing%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20have%20a%20second%20product%20document%20which%20includes%20trade%20prices%2C%20delivery%20and%20mark-up's.%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20of%20these%20documents%20have%20the%20same%20column%20providing%20the%26nbsp%3B%3CEM%3ESupplier%20Product%20ID%20Number%3C%2FEM%3E%20and%20%3CEM%3EProduct%20Name.%26nbsp%3B%3C%2FEM%3E%3C%2FP%3E%3CP%3EI%20am%20hoping%20to%20be%20able%20to%20merge%20the%20prices%20document%20to%20the%20product%20information%20document%2C%20getting%20the%20prices%20at%20the%20end%20of%20every%20row%20of%20the%20matching%20product%20by%20name%2Fid%20number.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20makes%20sense%2C%20I%20have%20attached%20an%20example%20document%20which%20includes%20a%20'product'%20and%20'prices'%20sheet%20to%20give%20you%20an%20idea%20of%20the%20situation.%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20extremely%20appreciated!%20Thank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3011854%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3011876%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Merging%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3011876%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231601%22%20target%3D%22_blank%22%3E%40ricciointeriors%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20any%20lookup%20function%2C%20for%20example%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIFNA(%20INDEX(Prices!G%3AG%2C%20MATCH(%20Product!%24B3%2C%20Prices!A%3AA%2C%200%20)%20)%2C%20%22no%20price%22%20)%0A%0Aor%0A%0A%3DXLOOKUP(%20%24B4%2C%20Prices!A%3AA%2C%20Prices!G%3AG%2C%20%22no%20price%22%20)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3013524%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Merging%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3013524%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there, if someone is able to help it would be greatly appreciated! 

I have 1 excel spreadsheet which has over 3,000 products; providing general product information such as colour, material, descriptions images and sizing etc. 

I also have a second product document which includes trade prices, delivery and mark-up's. 

Both of these documents have the same column providing the Supplier Product ID Number and Product Name. 

I am hoping to be able to merge the prices document to the product information document, getting the prices at the end of every row of the matching product by name/id number. 

I hope this makes sense, I have attached an example document which includes a 'product' and 'prices' sheet to give you an idea of the situation.

Any help would be extremely appreciated! Thank you in advance.

3 Replies

@ricciointeriors 

You may use any lookup function, for example

=IFNA( INDEX(Prices!G:G, MATCH( Product!$B3, Prices!A:A, 0 ) ), "no price" )

or

=XLOOKUP( $B4, Prices!A:A, Prices!G:G, "no price" )

 

@Sergei Baklan Thank you!

@ricciointeriors , you are welcome