Hi I have a holiday sheet thet requires the person allocating the holdiays for each year to input into the sheet along with the start year ie July 2013 to June 2014 and so on.
I have attached a sheet with the deisred outcome.
Thnaks in advance
JD
Hi I have a holiday sheet thet requires the person allocating the holdiays for each year to input into the sheet along with the start year ie July 2013 to June 2014 and so on.
I have attached a sheet with the deisred outcome.
Thnaks in advance
JD
I didn't download your file (it's too big for me!).
What type of data is it? Is it text? Numbers? Could be both? Something else?
This formula will return the last (right-most) TEXT entry from row 1:
=LOOKUP("zzzzz",1:1)
This formula will return the last (right-most ) NUMBER entry from row 1:
=LOOKUP(1E100,1:1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There you go I have attached a smaller sized file, hope you can open it.
JD
Ok, so you want the results that are currently displayed in cells B3 and C3?
Yes Please, they would be activated by the start date in the drop down list
JD
Try this...
Entered in B3 and copied across to C3:
=IFERROR(INDEX($G3:$O3,MATCH($B5,$G3:$O3,0)+COLUMNS($B3:B3)),"")
Fantastic, thank you so much.
JD
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks