Hi Eveyone
Please help me with the formula I need for this table.
I have tried VLOOKUP but cannot do it with the multiple variables I have .
I have attached a small spreadsheet to show what i require .
In cell A8 and A9 I have created a dropdown menus .
Once those cells have been populated i need an answer in cell F8 .
I have indicated in red what the answer would be in my example .
Seems simple , but I do not know how to do it .
Thanks in advance
Onesock
Bookmarks