I am trying to find the right formula for the following:

If Name in Column A on Sheet 1 matches the Name in Column A on Sheet 2,
I want the adjacent results from Column B on Sheet 2 to show in Column B
on Sheet 1.

The name columns do not necessarily have the same information in them.

Any help would be appreciated!

Thanks!


--
raspywench
------------------------------------------------------------------------
raspywench's Profile: http://www.excelforum.com/member.php...o&userid=20717
View this thread: http://www.excelforum.com/showthread...hreadid=389764