date lookup

  • Thread starter Thread starter Nigel Graham
  • Start date Start date
N

Nigel Graham

I need to use a lookup type enquiry to find a last updated
value in a spread sheet. Let me show you
a b c d e f g
1 Jan Feb Mar Apr May Jun Jul etc....
2 75 67 56 82 0 0 0

What I need to find is April as it is the last one with a
value in it. I need a forumula whigh will look at A2:?2
to find the last value from the left and then show the
date in the cell directly above it. I have seen this
before but can not find it anywhere and can't even think
how to do it other than ofset but cant work it out. Any
help would be useful.
Thanks in advance.
 
May, Jun, and Jul show 0's in your sample, while your description seems to
suggest that Apr is the latest entry with the remaining cells to the right
are empty. If you leave cells empty instead of entering 0's for "no value
yet", you can use the following formula to fetch the last month with a
value:

=INDEX(1:1,MATCH(9.99999999999999E+307,2:2))
 
Thanks for that the 0s are generated by other functions
which if there is no data ie. if(iserror(range,0,range) so
I have replaced the 0s with NA() and it works perfectly.
Thanks again.
I am always pleased with the speed of response and
resourcefullness/helpfullness of this group.
 
Back
Top