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

www.OfficeArticles.com
www.MyExpertsOnline.com



"avworld" wrote in
message ...

I'm trying to increment one value in a vlookup (or match) formula, but
not the other, for example:
=vlookup(B2, C2:C5000, 1)
I want the range to stay the same, but the value in B column to
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 time
to enter each cell individually.
Any help would be greatly appreciated.
Thanks,
Steve


--
avworld
------------------------------------------------------------------------
avworld's Profile:
http://www.excelforum.com/member.php...o&userid=24934
View this thread: http://www.excelforum.com/showthread...hreadid=384710