More thought on this...

B1 searches a specified column on a different worksheet for the value
in A1. If that value is found in the column on the other worksheet, B1
populates itself with the value in the cell column to the right of
wherever that value was found on the other worksheet.

Is that more clear? Was reading my previous post and it was rather
confusing.

Thanks in advance. I've found so many answers to my questions here
this the the firts time I've actually had to post one!


--
makega
------------------------------------------------------------------------
makega's Profile: http://www.excelforum.com/member.php...o&userid=29876
View this thread: http://www.excelforum.com/showthread...hreadid=495805