Forum Discussion
Help with this "IFS" statement in office 365
Hello Detlef,
I had another go with the look up formula and still don't get it
See attachemtent
Can you give some pointers
May be I am using the wrong type of formula.
What I am trying to achieve is, from a name in a cell (8 possible options) and a number in another cell (9 options) select a value from a range of cells (in one column) to give a value.
Example if there is water in this cell and the number is 3 then select the number 25
=LOOKUP(U31=3,S31="Bones"),(U31=1,S31="Butter”),(U31=1,S31="Cheese"),(U31=1,S31="Grass"),(U31=1,S31="Meat"),(U31=1,S31="Milk"),(U31=1,S31="Water"),(U31=1,S31="Whey"),25
and then I tried this option too.
=MATCH(U31=3,S31=Bones),(U31=1,S31=Butter),(U31=1,S31=Cheese),(U31=1,S31=Grass),(U31=1,S31=Meat),(U31=1,S31=Milk),(U31=1,S31=Water),(U31=1,S31=Whey),25
Please provide the workbook and not a photo of the workbook.
Detlef, I have attached the complete file as it stands now.
There are a numer of complete as well as incomplete components as you will see.
I was starting a slow process of working out each of the formulas.
It has nothing to do with milk or cheese, they were just easy names that did not need any explanation.
The particular formula I was discussing is on the tab called Pay Calculator where the two conditions are in Cell B3 and E8 with formula resulting in cell F8, H8, J8, L8.
So as the name or value changes in B3 or E8 then so will the values in F8, H8, J8, L8 change.
Thanking you for offering to have a closer look at the situation.
Luigi
http://www.OodlesofUtils.com
A Game of Choices and Trade Offs
Oh my. You are using the wrong quotes.
You are using character 147 (“) instead of character 34 (").
Well that is interesting!
Where do I find character 34?
To me 147 looks the same as 34
Is it a specific font type?