Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > list compare in excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

list compare in excel

Reply to Message Icon

Name: Captain8
Date: August 18, 2006 at 04:26:01 Pacific
OS: windows 2000
CPU/Ram: 256meg
Product: IBM T30
Comment:

If i have two list (one master, one slave). I want to record on the same row where a number in the slave list exists in the master.

Can anyone advise the formulae that might achieve this.

Thanks



Sponsored Link
Ads by Google

Response Number 1
Name: cach
Date: August 18, 2006 at 10:53:18 Pacific
Reply:

If the slave list is in the range I1:I10 and the master data is in column A, a formula like thisin column B should do it for row 1-then copy down the column

=+IF(ISERROR(VLOOKUP(A1,I$1:I$10,1,FALSE)),"missing","present")

Cliff


0

Response Number 2
Name: Captain8
Date: August 19, 2006 at 12:08:17 Pacific
Reply:

Cliff many thanks for the reply. By modifying your formulae to:

=+IF(ISERROR(VLOOKUP(A1,I$1:I$10,1,FALSE)),"missing",A1) the two numbers in each column equate which is what i need.

If i have data associated with the slave numbers how would i bring the associated data across in the next column.

My problem is i am trying to firstly make sure the numberin the slave exists in the master then compare the slave's data to the master data.

Master Master Slave Slave
Ref Data Ref Data

Any ideas?

Thanks


0

Response Number 3
Name: cach
Date: August 21, 2006 at 10:28:16 Pacific
Reply:

If the slave data is in column J, then you could display the relevant data if you replace the second A1 with

=vlookup(a1,I$1:J$10,2,false)


Cliff


0

Response Number 4
Name: Captain8
Date: August 25, 2006 at 02:56:36 Pacific
Reply:

Thanks Cliff


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: list compare in excel
Generate a List of Text in Excel www.computing.net/answers/office/generate-a-list-of-text-in-excel/7102.html

compare two columns in excel www.computing.net/answers/office/compare-two-columns-in-excel/7968.html

compare two columns in excel 2007 www.computing.net/answers/office/compare-two-columns-in-excel-2007/8119.html