Forum Discussion

bdaviesprox's avatar
bdaviesprox
Copper Contributor
May 12, 2019
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...
excel
Formulas and Functions
  • PeterBartholomew1's avatar
    PeterBartholomew1
    May 13, 2019

    bdaviesprox 

    LOOKUP requires the names to be in ascending alphabetical order so you need

    =LOOKUP(T12,{"Closed","Mixed","Open"},{100,50,20})

bdaviesprox's avatar
bdaviesprox
Copper Contributor
May 13, 2019

Thank you, though I cant seem to make this work with three options instead of four? Twifoo 

 

For example with another data set:-

 

=LOOKUP(T12,{"Open","Mixed","Closed"},{20,50,100})

Twifoo wrote:
You may use this formula in Column B:
=LOOKUP(A1,
{"High","Low","Medium","Zero"},
{100,20,50,0})

 

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
May 13, 2019

bdaviesprox 

LOOKUP requires the names to be in ascending alphabetical order so you need

=LOOKUP(T12,{"Closed","Mixed","Open"},{100,50,20})