JuicyMusic
Board Regular
 Joined
 Jun 13, 2020
 Messages
 159
 Office Version

 365
 Platform

 Windows
Hi, I've tried and tried and it just doesn't work. I'm certain that what I need is extremely simple. Please help me adjust my existing formula.
I will show you one formula that works great, and the other will be the one that I need to tweak.
I need the second formula to work even though the tab name (example: Thursday120320) does not exist. ISREF as well please.
FYI  Sometimes the tab that the VLOOKUP is looking for exists or does not exist because there was no labor performed on that day. The first formula works even if tab "Thursday120320" does not exist within the workbook.
Here is my excellent formula as a reference:
Here is my formula that I need to tweak in one column to the right of the 1st formula:
Thank so much, Juicy!
I will show you one formula that works great, and the other will be the one that I need to tweak.
I need the second formula to work even though the tab name (example: Thursday120320) does not exist. ISREF as well please.
FYI  Sometimes the tab that the VLOOKUP is looking for exists or does not exist because there was no labor performed on that day. The first formula works even if tab "Thursday120320" does not exist within the workbook.
Here is my excellent formula as a reference:
Excel Formula:
=IF(ISREF(INDIRECT("'"&K$8&"'!$A1")),IF(ISNA(VLOOKUP("*"&$C9&"*",INDIRECT("'"&K$8&"'!m6:m3056"),1,0)=FALSE),"Off/Vacation",$C9),"")
Here is my formula that I need to tweak in one column to the right of the 1st formula:
Excel Formula:
=IF(OR(K9="Off/Vacation",K9=""),"",
VLOOKUP("*"&$C9&"*",Thursday120320!$A:$B,2,0))
Thank so much, Juicy!