I am working on a sheet with the following:

Sheet 1 Col A = Description
Sheet 1 Col B = ID
Sheet 1 Col C = Returned value from Sheet 2 Col B when value in Sheet 1
Col B matches value in Sheet 2 Col A

I would like to take a cell from Sheet 1 Col B and find the matching
value in Sheet 2 Col A and fill in Sheet 1 Col C with associated value
from Sheet 2 Col B.

I know this is a simple lookup but I can't get it to work.


--
DebP
------------------------------------------------------------------------
DebP's Profile: http://www.excelforum.com/member.php...o&userid=32273
View this thread: http://www.excelforum.com/showthread...hreadid=520262