Nov 28 2021 06:09 AM
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.
Nov 28 2021 06:24 AM
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" )