Lookup function, keep range static

LoJames - Aug 27, 2010 at 02:18 PM
 LoJames - Aug 31, 2010 at 04:47 PM
I understand the Lookup Function in a simple way. I want to copy the Function statement down a column, to lookup data from another sheet. The range of cells adjusts to the row of the calculation when what I WANT is for the range to stay static, for both the match field and the result field.

Thanks in Advance

2 responses


Putting a $ sign before each part of the cell or range reference keeps it the same no matter where you put it.