SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 736
- Office Version
- 365
- Platform
- Windows
This VLOOKUP works fine.
=IFERROR(VLOOKUP(C3,'R:\Patient Results\[050119.xlsx]Bob'!$E$2:$F$569,2),"")
But I need the results to be blank if there's no file with that name or if the file exists but there's no tab within the file with that name. If I could get these 2 problems worked out it would allow me to use a standard form for every day without editing for workdays, vacations, holidays, etc. I think I could work out something that handled holidays but that wouldn't handle random days people didn't work.
Not everyone works every day and not every day is a work day.
=IFERROR(VLOOKUP(C3,'R:\Patient Results\[050119.xlsx]Bob'!$E$2:$F$569,2),"")
But I need the results to be blank if there's no file with that name or if the file exists but there's no tab within the file with that name. If I could get these 2 problems worked out it would allow me to use a standard form for every day without editing for workdays, vacations, holidays, etc. I think I could work out something that handled holidays but that wouldn't handle random days people didn't work.
Not everyone works every day and not every day is a work day.