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

Lookup function, keep range static
Network card function - Guide
Function key stuck on - Guide
Agp function - Guide
Find function on mac - Guide
Function of insert key - Guide

2 responses

Answer 1 / 2

Ray
Aug 30, 2010 at 03:38 PM

=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.

Answer 2 / 2

LoJames
Aug 31, 2010 at 04:47 PM

Thanks Ray!

Similar discussions

Find my Gmail account

Excel Macro - Set and autofill a range?

Dell laptop FN key is not working

Lookup table? Excel

Similar discussions

Subscribe To Our Newsletter!