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