Hello and thanks to everyone for helping me out. I think i am over complicating things for myself.



So i want for a cell to check 2 other cells and based on their combination set a value for that Cell based on the results.

Col. C Has a product / Col. D has a company. i want Col. F to check the combination of C and D and based on their combinations give me a Value that i have in a data sheet. There are 20 companies and 6 Products.

Ex:

C D F
Auto Company A 10%
House Company A 20%
Auto Company B 15%
Boat Company A 12%