Hi

I've not seen application.vlookup before, so I assume it's in
reference I've not got switched on.

If it works anything like the worksheet function vlookup, then you'l
need to put the column ID in the third parameter.

If your range goes from I to M, column I is 1, column J is 2 and so o
until column M which would be 5.

So your function would read:
Application.Vlookup(.cells(r,c), .range("I2:M400"), 5)

I'm not 100% sure that it will work, but it's somewhere to start...

G

--
grinning_cro
-----------------------------------------------------------------------
grinning_crow's Profile: http://www.excelforum.com/member.php...nfo&userid=651
View this thread: http://www.excelforum.com/showthread.php?threadid=39862