Help Merging Spreadsheets

[ricciointeriors]

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.

[#2]

@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" )

[#3]

@Sergei Baklan Thank you!

[#4]

@ricciointeriors , you are welcome