Can anyone help me on this
I have a table of "Rate Reference" on Sheet TableOfRef which depend on Type of Product and Color of product.
On other sheet (Sheet2) I have inputs of (Product / Color / Qty). Now I need the rate based on these inputs and the Table of Reference.
Example: I have (Product 9 / Blue / 10,000)
I check the table of Ref for that Product and Color and have the: "Qty/2500+100" So the rate would be: 10,000/2500+100 = 104
How can I formular cell E3?
See the attach
Thank a lot!!!
Bookmarks