VLOOKUP

  • Thread starter Thread starter Johnny
  • Start date Start date
J

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




.
Click to expand...
 
Back
Top