VLOOKUP

[Johnny]

I am doing a vlookup that will search for a cell in column
B and match it to another cell in column B much later.
The problem I am running into is that when i drag the
formula down the column, the range also changes. Is there
anyway I can work around this, I am trying to fill the
first 1400 rows, and dont want to paste the range into all
the rows....

VLOOKUP(B2,B1404:C34548,1,FALSE)

I want the B2 to change as i drag the formula down, but
not the range B1404:C34548. Any thoughts? Thanks a
million

 

[Norman Harker]

Hi Johnny!

Try
VLOOKUP(B2,$B$1404:$C$34548,1,FALSE)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[JulieD]

Hi Jonny

try this
=VLOOKUP(B2,$B$1404:$C$34548,1,FALSE)

the $ is the sign for an absolute reference.

Hope this helps
Cheers
JulieD

 

[Johnny]

That worked out beautiful THANKS!!!!!!!!!!!!

-----Original Message-----
Hi Jonny

try this
=VLOOKUP(B2,$B$1404:$C$34548,1,FALSE)

the $ is the sign for an absolute reference.

Hope this helps
Cheers
JulieD




.