trouble "locking" a portion of a formula..

[avworld]

I'm trying to increment one value in a vlookup (or match) formula, bu
not the other, for example:
=vlookup(B2, C2:C5000, 1)
I want the range to stay the same, but the value in B column t
increment so I can just fill the rest of the column.

ie:
=vlookup(B3, C2:C5000, 1)
=vlookup(B4, C2:C5000, 1)
etc.

Any thoughts?
There are actually over 12,000 rows, and I really don't have the tim
to enter each cell individually.
Any help would be greatly appreciated.
Thanks,
Stev

 

[Anne Troy]

Try this:
=vlookup($B2, $C$2:$C$5000, 1)
Or use a named range such as described here:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[avworld]

that worked perfectly.
I figured there was a way to define a range with a variable name, I
just didn't know how to do it in excel.
you've saved me a few hours of programming.
Thanks,
Steve