Centralized Excel sheet and a way to find values based on 3 criterias

Hi,

We have an excel sheet with fields pid, width,height,price. This sheet contains pricing for all of our products, and is generated nightly.

For each product, we also have a separate sheet with the same fields. We want to keep the pricing on these sheets in sync with the priucing on the sheet above. Is there a way to tell these separate sheets, to look for the pricing on the sheet above by looking for the matching combo of pid, width and height, so that once it finds it, it copies the price from that sheet to the separate sheets?

Please let me know if any ideas.

Thanks,
Tim

Pl post a file With Dummy data in the same format.

I just attached 2 files:

Centralized file - which is the source and as you can see the columns in red are the matching condition and the column in yellow is the value which I need to use.

Consumer - which is the file where the value needs to be replaces based on the 3 criterias: width, height, ProductID.

Centralized.xlsxConsumer.xlsx

I know that it can be done with other solutions but bu boss what's to stick to excel only.

thanks!

I know that it can be done with other solutions but bu boss what's to stick to excel only.

thanks!