VLOOKUP question

crimlet · May 17th, 2002, 01:35 AM

when using VLOOKUP eg:-
=VLOOKUP($A2,[book]sheet!$A$153:$BG$8000,2,FALSE)

is there an easy way of incrementing the cell the info is retreived from by one so that the next cell will be: -

=VLOOKUP($A2,[book]sheet!$A$153:$BG$8000,3,FALSE)

Ian Mac · May 17th, 2002, 02:28 AM

Quote:

On 2002-05-17 00:35, crimlet wrote:
when using VLOOKUP eg:-
=VLOOKUP($A2,[book]sheet!$A$153:$BG$8000,2,FALSE)

is there an easy way of incrementing the cell the info is retreived from by one so that the next cell will be: -

=VLOOKUP($A2,[book]sheet!$A$153:$BG$8000,3,FALSE)

=VLOOKUP($A2,[book]sheet!$A$153:$BG$8000,COLUMN(),0)

0 is the same as FALSE.

Chris Davison · May 17th, 2002, 10:56 AM

Hi Ian,

just in case the original formula isn't in column B, we probably ought to secure the "2" with COLUMN(B:B)

which, of course will copy over to C:C (3) and D:D (4) etc etc as you'd planned

thusly :

=VLOOKUP($A2,[book]sheet!$A$153:$BG$8000,COLUMN(B:B),0)

Chris

2 days to bowl Sri Lanka out.... sheeesh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 01:35 AM	#1
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	when using VLOOKUP eg:- =VLOOKUP($A2,[book]sheet!$A$153:$BG$8000,2,FALSE) is there an easy way of incrementing the cell the info is retreived from by one so that the next cell will be: - =VLOOKUP($A2,[book]sheet!$A$153:$BG$8000,3,FALSE)

May 17th, 2002, 10:56 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Hi Ian, just in case the original formula isn't in column B, we probably ought to secure the "2" with COLUMN(B:B) which, of course will copy over to C:C (3) and D:D (4) etc etc as you'd planned thusly : =VLOOKUP($A2,[book]sheet!$A$153:$BG$8000,COLUMN(B:B),0) Chris 2 days to bowl Sri Lanka out.... sheeesh