You can use a vlookup. Here's how:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"raspywench" wrote
in message ...

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