Last Row Value

[Robert Christie]

Hi
I want to place a function in cell F3 to add the cell G3
on the same sheet to the last value of a cell on a second
sheet in Column C.
The Column on second sheet is added to on a regular
weekly basis.
Something along the line of i.e
=G3+ "second Sheet" Column C lastrow.value
Data on second sheet starts on row 4.
Hope you can help
TIA
Bob C

 

[Biff]

Hi Robert,

Here's one way:

=G3+LOOKUP(9.99E+307,Sheet2!C4:C65536)

Biff

 

[Robert Christie]

Just what the docter ordered.
Thanks Biff, worked a treat

Bob C