S
Suzy
I have formulas:
J34: =LOOKUP(9.9999999999+307,E78:E89) correctly returned
as 183.8 from E84
I34: =LOOKUP(J34,E78:E89,A78:A89)
A78 to A89 displays Jan 2004 to Dec 2004 (all dates
formatted as mmm yyyy)
I34 however is being returned as Apr 2004 (A81, which in
corresponding cell E81, is 183.6) rather than Jul 2004 at
A84.
I'm unsure if I have explained this very well, but can
anyone identify what have I done wrong?! Can anyone
help....please?!
Many thanks and regards.
J34: =LOOKUP(9.9999999999+307,E78:E89) correctly returned
as 183.8 from E84
I34: =LOOKUP(J34,E78:E89,A78:A89)
A78 to A89 displays Jan 2004 to Dec 2004 (all dates
formatted as mmm yyyy)
I34 however is being returned as Apr 2004 (A81, which in
corresponding cell E81, is 183.6) rather than Jul 2004 at
A84.
I'm unsure if I have explained this very well, but can
anyone identify what have I done wrong?! Can anyone
help....please?!
Many thanks and regards.