Compare one column to another in a different spreadsheet

**billyhasnotalent** · 02-16-2011, 10:53 AM

Hi,

There is probably an easy solution to this but I don't know where to get started.

I have one spreadsheet, a sheet containing all sales for the year, with a column containing about 50,000 cells of data, they are customer IDs in sales transactions.
In the other spreadsheet I have a master customer file, sorted by customer ID.

I want to create a formula that would display an X (anything I could use to do a "sort") next to the customer ID in the master customer file if their customer ID is shown in the sales for the year spreadsheet. Basically, I want an X next to their name if they made a sale.

Any suggestions?

**NBVC** · 02-16-2011, 11:06 AM

Try:

=IF(ISNUMBER(MATCH(A2,'SalesSheet'!A:A,0)),"X","")

where A2 contains first ID in Master sheet and SalesSheet!A:A is column A on sheet named SalesSheet containing the IDs to look for. Adjust as necessary

copied down.

Compare one column to another in a different spreadsheet

LinkBack

Thread Tools

Rate This Thread

Display

Compare one column to another in a different spreadsheet

Re: Compare one column to another in a different spreadsheet

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions