Forum Discussion
Help Merging Spreadsheets
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, descr...
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" )
SergeiBaklan Thank you!
ricciointeriors , you are welcome
