I checked your file. The ajc range referred to in your VLOOKUP formulas
stops at row 199. You need to redefine the ajc range to extend below
row 199 in order to match the missing items.

•InsertNameDefine
•Select the name "ajc"
•Tab once to select Refers To
•Extend the range as far down as you will need.

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=482797