Lookup
in [Functions]
|
From: Yrrep on 27 Feb 2010 18:53 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
From: teylyn on 27 Feb 2010 19:50 You can use somthing like =VLOOKUP(99^99,Sheet1!A1:A1000,1,TRUE) regards teylyn Y r r e p ; 6 5 6 6 5 3 W r o t e : > 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 [url="http://www.thecodecage.com"]Microsoft Office Help[/url]
From: Yrrep on 27 Feb 2010 22:06 Thanks Just what I needed "teylyn" <teylyn.472jf1(a)thecodecage.com> wrote in message news:teylyn.472jf1(a)thecodecage.com... > > You can use somthing like > > =VLOOKUP(99^99,Sheet1!A1:A1000,1,TRUE) > > regards > > teylyn > > > Yrrep;656653 Wrote: >> > 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 > > [url="http://www.thecodecage.com"]Microsoft Office Help[/url] >
|
Pages: 1 Prev: Count Wednesdays within a calendar month Next: Using validation to make data appear or not |