Find latest value in a series.

[Mattlynn via OfficeKB.com]

Hi
I have 4 rows of data.
Row 1 = Months of the year, Jan, Feb etc
Row 2 = target Values
Row 3 Actual Values
Row 4 Amber Values (vary between 80-90% of target)

I am creating a graph on separate tab and as a summary would like to bring
back the latest value on each row.
So if i complete for July, the summary will show me Target Actual and Amber
in 3 diff cells next to graph for July. If i plug in Aug data, the summary
changes to that data.

I have had a play with various methids, but cant cracki t.
Hopefully i have explained ok for all,
Can anyone help?
Many Thanks
Matt

 

[Teethless mama]

=LOOKUP(1E100,1:1)

 

[Mattlynn via OfficeKB.com]

Hi teethless - sorry but i do not understand the formula suggestion you have
given?
Thanks

Can you please explain?

=LOOKUP(1E100,1:1)

Hi
I have 4 rows of data.

[quoted text clipped - 14 lines]

Many Thanks
Matt

 

[T. Valko]

TM's formula will return the last (rightmost) numeric value from row 1.

If that's what you wanted then just change the range reference to suit your
application. For example:

=LOOKUP(1E100,Sheet1!D5:J5)

--
Biff
Microsoft Excel MVP

Hi teethless - sorry but i do not understand the formula suggestion you
have
given?
Thanks

Can you please explain?

=LOOKUP(1E100,1:1)

Hi
I have 4 rows of data.

[quoted text clipped - 14 lines]

Many Thanks
Matt

 

[Mattlynn via OfficeKB.com]

Thats brillaint - Thanks T Valko and thanks teethless mama

TM's formula will return the last (rightmost) numeric value from row 1.

If that's what you wanted then just change the range reference to suit your
application. For example:

=LOOKUP(1E100,Sheet1!D5:J5)

Hi teethless - sorry but i do not understand the formula suggestion you
have

[quoted text clipped - 10 lines]

 

[Mattlynn via OfficeKB.com]

thanks teethless mama - thats an outstanding formula - thanks again!

=LOOKUP(1E100,1:1)

Hi
I have 4 rows of data.

[quoted text clipped - 14 lines]

Many Thanks
Matt

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thats brillaint - Thanks T Valko and thanks teethless mama

TM's formula will return the last (rightmost) numeric value from row 1.

If that's what you wanted then just change the range reference to suit
your
application. For example:

=LOOKUP(1E100,Sheet1!D5:J5)

Hi teethless - sorry but i do not understand the formula suggestion you
have

[quoted text clipped - 10 lines]

Many Thanks
Matt

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200910/1