Compairing data

  • Thread starter Thread starter m4tt
  • Start date Start date
M

m4tt

Hi,

I need to make a spreadsheet that can compair two different
spreadsheets. The problem is there is no ID no. or unique identifier
that can match the data.

The spreadsheet needs to take one of the criteria for a product in s/s
A and look it up in s/s B. It will then need to get another one of the
criteria and of the product to check that, that look up is correct, and
so on till all the criteria for that product have been matched on both
s/s. if there are no matches it can display n/a.

Please help some one.

Thanks,

Matt
 
If you give an example of the data on each sheet, and describe what
you're trying to match, someone may be able to help.
 
Hi,

ive been thinking about this a bit more and i kind of need a vlookup
that will look at multiplue values.

Ive made a simple mock up of the kind of thing im trying to make, its
copied from excel so i hope it can be read ok.

Thanks for your help

A
ID clothing colour size
1 tshirt red 1
2 tshirt red 2
3 tshirt blue 1

B
ID clothing colour size
a tshirt blue 1
b tshirt red 1
c tshirt red 2

Result
A ID B ID clothing colour size
1 b tshirt red 1
2 c tshirt red 2
3 a tshirt blue 1
 
You could insert a new column at the left of the existing columns, on
sheets A and B.
Add a heading, e.g. "Description"
In cell A2, enter the formula:
=C2&"--"&D2&"--"&E2
Copy the formula down to the last row of data

Add a column to the right of the existing columns, on sheets A and B.
Add a heading, e.g. "Match"
On sheet A, in cell F2, enter the formula:
=VLOOKUP(A2,SheetB!$A$2:$B$4,2,FALSE)
Change the $A$2:$B$4 reference to match the number of rows on sheetB
Copy the formula down to the last row of data

On sheet B, in cell F2, enter the formula:
=VLOOKUP(A2,SheetA!$A$2:$B$4,2,FALSE)
Change the $A$2:$B$4 reference to match the number of rows on sheetA
Copy the formula down to the last row of data
 
Back
Top