Hi,

I have created a VLOOKUP formula which creates the correct answer for me.

However, i need to fill down the formula for the whole spreadsheet (about
38,000 rows) that i am working on. When i do this it moves the lookup table
down one row each time i fill.

Is there some way that i can copy or fill down the formula without having
the lookup table in the formula change with every row?

Thanks