Thanks for you suggestion of
VLOOKUP(Sheet1!D5,Sheet2!$D:$E,2,FALSE)

That works but still have some minor issues. Here is my proble
though. Column B in the first sheet does not have data on every lin
but every 3rd line and I cannot disturbe the data between the cells
want to check. So I cannot copy and paste:

VLOOKUP(Sheet1!D5,Sheet2!$D:$E,2,FALSE)

into column B as it would erase everything.

I need the function to work on on another file or sheet with columns
and D and if a change needs to be made it would enter that value int
the proper cell in the B column.

Shew

--
kausewa
-----------------------------------------------------------------------
kauseway's Profile: http://www.excelforum.com/member.php...fo&userid=1512
View this thread: http://www.excelforum.com/showthread.php?threadid=26761