Calculation based on Table Value & Lookup

Hi all,

Sorry i am new to this so please forgive me if this thread is in the incorrect place. I am trying to do a division formula based on a lookup from one column to a table and then divide against a figure in a different column. This may not make sense so i will try and put a demonstration below. Thanks very much in advance for any help anyone can provide.

Table to look up

Colour Daily Volume
Blue 76
Red 260
Green 132
Yellow 329

Part Data
Part Colour ADU Column D
123 Blue 36
321 Red 4
432 Green 2
658 Red 84
789 Blue 40

So essentially i want a formula in column "D" to lookup the correct colour in the lookup table, get the Daily voulme and then divide that figure by the ADU.

Thanks Again

Hi,

Welcome to the Forum.

Can you upload a small excel file showing the expected results with enough examples? Make sure your desired results are shown, mock them up manually if necessary. Remember to desensitize the file by removing confidential information before upload!

See the following URL for help on how to upload a file.
http://www.excelforum.com/members/da...ch-a-file.html

Thanks for your reply guys, think i have attached the document but not sure.

Sorry i have now done it, thank you all for your help. The formula i used was =EF13/VLOOKUP(M13,$E$3:$G$7,3,0)

Thank you again.

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.