MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comparing Two Worksheets

Posted by Cindy on February 26, 2001 2:54 PM

In simple terms please...Worksheet 1 is student id# and name, Worksheet 2 is all student bio/demo info including id#. I need to compare the two, and pull bio/demo info for all students on worksheet 1 from worksheet 2. Thank you!

Posted by David Hawley on February 26, 2001 5:00 PM

Hi Cindy

Rather than reinvent the wheel here, take a look at this utility.

Might just be exactly what you are after.


OzGrid Business Applications

Posted by Faster on February 26, 2001 5:10 PM

Use the function wizard to walk you through: VLOOKUP