Putting a small lookup list inside a formula

  • If I have a simple lookup to do, eg =lookup(weekday(today()),lookup_range,return_range)


    instead of having a column of numbers 1 to 7 and a corresponding column of weekdays, is there any way of incorporating the list into the formula so it only uses the one cell?


    I could do it with IF functions for this particular example easily, but for other things it would make sense if I could put the lookup list in the formula


    Thanks a bundle


    Tony

  • Hi,


    maybe CHOOSE function does for the serial date
    e.g.
    =CHOOSE(WEEKDAY(TODAY()),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
    or
    =LOOKUP(WEEKDAY(TODAY()),{1,2,3,4,5,6,7;"Sun","Mon","Tue","Wed","Thu","Fri","Sat"})
    ??

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!