Vlookup Question regarding sequential rows

[Novellas]

=VLOOKUP($D38,Mosiac!$D$7:$EC$2800,18,FALSE)

Above is the VLookup formual I am using.

Problem I'm having is I do not know how to instruct the formula, when I copy it over to the next column, to auto-select the next sequential row number:

In this case, =VLOOKUP($D38,Mosiac!$D$7:$EC$2800,19,FALSE), 20, 21, ...


What's the secret?


Thx

 

[DeBeuz]

You could try to replace 19 with a calculation based on row(<some cell>).
For instance row(d38)+15.

Hope this helps.

Paul

 

[Novellas]

Thanks Paul, but the data is based on the Mosaic tab; the calc based on row isn't pulling from the correct data set

Appreciate the Reply

 

[T. Valko]

=VLOOKUP($D38,Mosiac!$D$7:$EC$2800,18,FALSE)

Above is the VLookup formual I am using.

Problem I'm having is I do not know how to instruct the formula, when I copy it over to the next column, to auto-select the next sequential row number:

In this case, =VLOOKUP($D38,Mosiac!$D$7:$EC$2800,19,FALSE), 20, 21, ...


What's the secret?


Thx

One way...

=VLOOKUP($D38,Mosiac!$D$7:$EC$2800,COLUMNS($A1:R1),0)

COLUMNS($A1:R1) evaluates to 18. As you drag copy across a row it will increment to:

COLUMNS($A1:S1) = 19
COLUMNS($A1:T1) = 20
COLUMNS($A1:U1) = 21
COLUMNS($A1:V1) = 22
etc
etc

 

[Novellas]

That did it! Thanks T. Valko!

Appreciate all the help from everyone! Love this site!

 

[T. Valko]

That did it! Thanks T. Valko!

Appreciate all the help from everyone! Love this site!

You're welcome. Thanks for the feedback!

 

[Novellas]

DeBeuz--that works too, good deal!