Forum Discussion
analysis of an entry
What I use is the "IFS" function.
create a table with your labels and values,
then use =IFS to identify what label you typed and find the corresponding value.
Example, I type a label in H3, in I3 I have this IFS formula to go find that label on my table and give me the corresponding value:
=IFS(H3=$AF$1,$AE$1,H3=$AD$1,$AC$1,H3=$AB$1,$AA$1,H3=$Z$1,$Y$1,H3=$X$1,$W$1,H3=$V$1,$U$1,H3=$AH$1,$AG$1)
No not really?
i have a data base of values, that are identified against a label, each label has a different value,
so I want to enter any of the labels in a cell and next to it get the corresponding value for that label as identified in the data table.
Its basically for me to get a value by recording the differing labels only?
to be truthful, I want to do an MTM analysis using descriptions of action, each has a value and then at the end of the list I want a total.
i have managed to get my sheet to enter a value specific to a description, but I want to enter any label in a cell and the corresponding value come back in the cell next to it.
What I use is the "IFS" function.
create a table with your labels and values,
then use =IFS to identify what label you typed and find the corresponding value.
Example, I type a label in H3, in I3 I have this IFS formula to go find that label on my table and give me the corresponding value:
=IFS(H3=$AF$1,$AE$1,H3=$AD$1,$AC$1,H3=$AB$1,$AA$1,H3=$Z$1,$Y$1,H3=$X$1,$W$1,H3=$V$1,$U$1,H3=$AH$1,$AG$1)
- absolutely perfect
thx