Excel has a series of Database functions, but to be honest they are hard for
me to use. I have done what you are looking by Concatenating the cells
thereby creating the unique data you are looking for. You can create a new
column with the concatenated cells
+Concatenate (item #,"_", date,"_",location,"_", quantity)
You can then create a lookup using vlookup to find the unique value that you
are seeking.
Another option is a pivot table. Great tool for this, but a bit hard to
learn.
"Connie" wrote:
I have 2 spreadsheets with data from 2 systems.
What I need is to take specific data from sheet 1 and match it to the
corresponding line in sheet 2. The problem comes in that each sheet only has
a unique entry if I search based on a combination of 4 columns (item #, date,
location and quantity).
For any one of these search items there will multiple entries, but for the
combination of all 4 there should be one unique entry.
How can I accomplish this to compare the two spreadsheets?
|