Lookup function, keep range static

Closed
LoJames - Aug 27, 2010 at 02:18 PM
 LoJames - Aug 31, 2010 at 04:47 PM
Hello,
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 replies

=VLOOKUP($F$3,$B$3:$C$7,2,FALSE)

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