Comparing unsorted data across separate files

Closed
TechNotAAnalyst Posts 1 Registration date Friday August 22, 2014 Status Member Last seen August 22, 2014 - Aug 22, 2014 at 11:05 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 23, 2014 at 11:55 AM
I need an automated way to compare the 2 sheets to make sure no equipment gets missed for ordering. I have to compare an order for equipment against an inventory of equipment to make sure everything is getting ordered. In my inventory sheet all the serial numbers are in column E, the data is sorted by column C which has the location info. The order sheet has the serial numbers in column G, sorted by location in column C. The serial number columns are not sorted the same way so a direct comparison can't be done.
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 23, 2014 at 11:55 AM
TechNotAAnalyst, Good afternoon.

You did not say how you want the comparison be made.
Column C (location) has some importance in this comparison?

Here is a formula to compare serial numbers.
=IF(ISERROR(MATCH(E2,order!$G$2:$G$11,0),0)>0,"OK","NOT ORDERED")
Adapt as your reality.
Put this f'ormula in column F of the spreadsheet inventory.
Copy IT down.

If you prefer, save your excel file at a free site, www.speedyshare.com and put a link here to download.

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0