Nested IF and HLOOKUP with too many arguments

[Jediantman]

Hi all,


I have a bit of a problem with a spreadsheet that I use to control the timeline of the life of certain reports. The original spreadsheet we use was created by an outside consultant, who no longer works with us, and so it has been adapted as things have changed however the construct and formulas used have largely remained the same.


Put as simply as I can, I have to use a formula to populate a cell with a specific date. This date will be generated from the previous steps in the timeline (which is perfectly simple) but needs to take into account a myriad of holiday dates that will be determined by the local authority the report is for. The local authority is held in one of the cells in the spreadsheet and so I then need to match that against the appropriate dates. There are 55 local authorities, which between them have a combination of 9 different holiday date ranges.


I have a sample workbook that I can share if it would be any use, although I can't see anywhere to upload it here.


Please help, thank you.

 

[Montrey]

Definitely going to need a sample workbook. Look at the green sticky posts on the main forum view to learn how to upload a file.

 

[Jediantman]

I've actually managed to sort it now, thanks, by changing to a vlookup and using another IF to qualify it all. Thanks for the offer, I just needed to to step back to separate the wood from the trees!!

 

[SirJB7]

Hi, Jediantman!

Would you please share explicitly the solution so as the community could read it? Thank you.

Regards!