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%

Hi
clear as mud. Please post a sample sheet with some data (10-20 rows) and manually evaluated results. Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hello and sorry i did not know how to post data sheets.

So what i would like the F cell to do is look at cells C and D and when it has the right combination apply the proper %. The percentage information is on the DATA sheet. I tried to do a True or false...but i quickly feltthat there was surely a better way.

Thank you for taking the time to respond and help.

It is much appreciated.

Attached Files

Calculateur VenteCommission (Ver.2.0).xlsx (18.6 KB, 2 views)

You should avoid using merged cells (row 4) and that kind of layout. I partially rebuilt your table ( colored background starting DATA sheet A31) to a simple excel list which is much more efficient.You can then add all you want keeping the layout.
From there, a simple XLOOKUP does the trick. (adapt the ranges or make your range an Excel Table,...)

PS ça devrait le faire sans difficultés

Attached Files

Calculateur VenteCommission (Ver.2.0).xlsx (19.8 KB, 3 views)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks so much for everything! Really appreciate it

Merci Beaucoup pour tout! J'apprécie vraiement!

You're welcome. Adding some rep would also be appreciated

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post