Lookup

[Yrrep]

I have a work sheet with a column of numbers, that are always being added
to.

I want use a different worksheet to lookup the last number in the column in
the first sheet.

i.e. vlookup last number in sheet 1 and place in sheet 2

 

[Yrrep]

Thanks Just what I needed

You can use somthing like

=VLOOKUP(99^99,Sheet1!A1:A1000,1,TRUE)

regards

teylyn


I have a work sheet with a column of numbers, that are always being
added

to.

I want use a different worksheet to lookup the last number in the column in
the first sheet.

i.e. vlookup last number in sheet 1 and place in sheet 2

--
teylyn

Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com)
------------------------------------------------------------------------
teylyn's Profile: 983
View this thread:
http://www.thecodecage.com/forumz/showthread.php?t=183271

Microsoft Office Help