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


  • Hi,

    maybe CHOOSE function does for the serial date

Participate now!

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