ExcelBanter - Fill series

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Fill series (https://www.excelbanter.com/excel-discussion-misc-queries/143375-fill-series.html)

Marty

Fill series

I need to easily fill about 90 cells in a column with the formula below where
the number following (A increases by 1 in every cell down the column. How can
I do this?

=VLOOKUP(A2,G1:H88,2,FALSE)

Teethless mama

Fill series

=VLOOKUP(A2,$G$1:$H$88,2,FALSE)

"Marty" wrote:

I need to easily fill about 90 cells in a column with the formula below where
the number following (A increases by 1 in every cell down the column. How can
I do this?

=VLOOKUP(A2,G1:H88,2,FALSE)

Marty

Fill series

Thank you so much!!!

"Teethless mama" wrote:

=VLOOKUP(A2,$G$1:$H$88,2,FALSE)

"Marty" wrote:

I need to easily fill about 90 cells in a column with the formula below where
the number following (A increases by 1 in every cell down the column. How can
I do this?

=VLOOKUP(A2,G1:H88,2,FALSE)

All times are GMT +1. The time now is 09:16 AM.