I have a spreadsheet attached which has thre pull down menus (lists), also in E2 is an output file, The formula I need is to fill a qauntity in E2 when seveal of the options are selected, for example when A1=380, A2=RED & A3 =E i want E2 to display 5.
another example, when A1=208, A2=BLUE & A3 =F I WANT E2 =10.
I can write the formula for two cells to = 5 but struggle to enter a code for all three, any suggestions please?
Bookmarks