A
Anthony King
I need to create a query comparing 2 excel spreadsheets where the contents of
1 sheet are not found in the other spreadsheet.
1 sheet are not found in the other spreadsheet.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
maurrieske
why not working in Excel itself with te Vlookup formula?
Maurrieske
Maurrieske
A
Anthony King
new to both access and excel will 'lookup' give me what I want?
A
Anthony King
new to both access and excel how do u "lookup"?
A
Anthony King
not finding Vlookup in the excel for dummies book
M
maurrieske
Make a new excel workbook.
Copy the sheets from the to excel files you want to compare to this new
workbook. Name one sheet CS_1 and th other CS_2.
Then add two new sheets to this workbook. Name these sheets CS_1_check and
CS_2_check
Put in range A1 on sheet CS_1_check the following formula
=VLOOKUP(CS_1!A1,CS_2!A:A,1,0)
copy this formula to the same range then there are values to compare on
sheet CS_1
All cells with a #N/B as a result are in the sheet CS_1 but not in the same
column in sheet CS_2
Then put in range A1 on sheet CS_2_check the following formula
=VLOOKUP(CS_2!A1,CS_1!A:A,1,0)
also copy this formula to the same range then there are values to compare on
sheet CS_2
All cells with a #N/B as a result are in the sheet CS_2 but not in the same
column in sheet CS_1
With this formula you should get wat you want.
Maurrieske
Copy the sheets from the to excel files you want to compare to this new
workbook. Name one sheet CS_1 and th other CS_2.
Then add two new sheets to this workbook. Name these sheets CS_1_check and
CS_2_check
Put in range A1 on sheet CS_1_check the following formula
=VLOOKUP(CS_1!A1,CS_2!A:A,1,0)
copy this formula to the same range then there are values to compare on
sheet CS_1
All cells with a #N/B as a result are in the sheet CS_1 but not in the same
column in sheet CS_2
Then put in range A1 on sheet CS_2_check the following formula
=VLOOKUP(CS_2!A1,CS_1!A:A,1,0)
also copy this formula to the same range then there are values to compare on
sheet CS_2
All cells with a #N/B as a result are in the sheet CS_2 but not in the same
column in sheet CS_1
With this formula you should get wat you want.
Maurrieske
J
John W. Vinson
On Mon, 20 Aug 2007 09:34:01 -0700, Anthony King <Anthony
What's the structure of the datasheet? How do you define a "match" or a
"mismatch" - one field? several fields? all the fields?
You can use File... Get External Data... Link to connect to the spreadsheets,
and use the "Unmatched Query Wizard" on the new Query window if it's a
straightforward one-field match. If you need more, post back with more info.
John W. Vinson [MVP]
I need to create a query comparing 2 excel spreadsheets where the contents of
1 sheet are not found in the other spreadsheet.
What's the structure of the datasheet? How do you define a "match" or a
"mismatch" - one field? several fields? all the fields?
You can use File... Get External Data... Link to connect to the spreadsheets,
and use the "Unmatched Query Wizard" on the new Query window if it's a
straightforward one-field match. If you need more, post back with more info.
John W. Vinson [MVP]