Could i?

[brownoz]

hi i have a sheet that has i products and what planograms these items are on. Could i have other sheets that display a all the products and then all the plangorams that product is displayed on, how would i pull the data from one sheet to another? like the below.

 

[Sergius]

Hello! It's hard to say anything without seeing the structure of your tables. Therefore, if in the photo this is your general table where you want to pull the data, then write the name of the product in the first column, and pull the data into the remaining columns using the INDEX and MATCH functions.

 

[brownoz]

Hello! It's hard to say anything without seeing the structure of your tables. Therefore, if in the photo this is your general table where you want to pull the data, then write the name of the product in the first column, and pull the data into the remaining columns using the INDEX and MATH functions.

thank you i will try that.