Forum Discussion
Solved
{Solved} How To: Select from a list of options to display a Label
Hello, I am working on a spreadsheet for work for our scheduling and I ran into some difficulty. I reached a part where I am trying to set up a list for special events such as vacations or meetin...
- Try this:
=IF(A4=“”,””,
IFERROR(LOOKUP(2,1/(
(S$4:S$23=A4)*(R$4:R$23=B4)),
T$4:T$23),”OFF”))
Try this:
=IF(A4=“”,””,
IFERROR(LOOKUP(2,1/(
(S$4:S$23=A4)*(R$4:R$23=B4)),
T$4:T$23),”OFF”))
=IF(A4=“”,””,
IFERROR(LOOKUP(2,1/(
(S$4:S$23=A4)*(R$4:R$23=B4)),
T$4:T$23),”OFF”))
This almost got it perfect. I had to lock in a few of the cells in the formula to get them to work when copy pasted but that was easy. The only issue now is it says OFF if there is no event rather then no time in B4. I'm going to try something though and get back with an update.
I got it. Ended up with=IF($A4="","",IFERROR(LOOKUP(2,1/(($S$4:$S$23=$A4)*($R$4:$R$23=B$3)),$T$4:$T$23),IF(B4="","OFF","")))
Just had to change the ending part there.
- I’m glad you did.