Web Development

General discussion

Gravatar
Locked

Excel Data Comparison - Lookup

By doyle.cone ·
I have two separate worksheets. Worksheet 1 contains a list of position #s (personnel). Worksheet 2 contains a list of position #s (Column A) with individual names (Column B). My task is to compare position #s in the two worksheets and when they match, copy and paste the corresponding user name from Worksheet B to Worksheet A adjacent to the appropriate position #. Any help would be appreciated.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

Third-Party Software

by BFilmFan In reply to Excel Data Comparison - L ...

Asked and answered here that you will need Third-Party Software to perform this task:

http://exceltips.vitalnews.com/Pages/T0118_Comparing_Workbooks.html

Excel COmpare will do this:

http://www.formulasoft.com/

gravatar
Collapse -

Not even close!

by wordworker In reply to Third-Party Software

Nice try BFF but you're way off. He's comparing data in worksheets, not workbooks.

gravatar
Collapse -

Opps

by BFilmFan In reply to Not even close!

Yah I did misread that. My bad...

gravatar
Collapse -

Checking Software

by doyle.cone In reply to Third-Party Software

I sent an email to their tech support to see if their software will do the trick. If not, will get my programmer to work the solution. Thanks for your put.

gravatar
Collapse -

Excel Data Comparison - Lookup

by carlos In reply to Excel Data Comparison - L ...

Have you tried VLOOKUP function?

It looks like this:
=Vlookup(A1,Sheet2!A1:B20,1,False)

Where "Sheet2!A1:B20" would be the range of cells that contains your table. And the third parameter is the column index of the table.

In this function column indexes start from 1.

If the #s is not found it retuns an error which i easily manage with the IsError() Function.

Hope this helps.


Carlos

gravatar
Collapse -

VLookup

by doyle.cone In reply to Excel Data Comparison - L ...

Yes Carlos VLookup can get me the True, False between the two values. The real challenge, which I'm thinking will require some additional code outside Excel, is populating the name field when True. Appreciate the help.

gravatar
Collapse -

Small correction to Carlos solution

by bschaettle In reply to VLookup

All you need to do is change Carlos' solution slightly to return the second column instead the first:

=Vlookup(A1,Sheet2!A1:B20,2,False)

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Start or search

Related Discussions

Related Forums