Forum Discussion
Solved
Help - got a little lost with a formula solution and now confused!
Hi there, am sure this will be easy for the community but your help would be a life saver after going around the houses with my feeble attempts. Ok so here it is:- I have a blank column which is...
LOOKUP requires the names to be in ascending alphabetical order so you need
=LOOKUP(T12,{"Closed","Mixed","Open"},{100,50,20})
bdaviesproxHere you go..
=CONCATENATE(A2,IF(A2="ZERO","= 0",IF(A2="LOW","= 20",IF(A2="MEDIUM","= 50",IF(A2="HIGH","= 100",0)))))
If I do this then my cell ends up as 'High=100' in the cell, I just want the figure....