Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Maybe??
I have 2 differant spreadsheets and need to find matching data on them. What
would I use to do it and how? TIA -- Mary C |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Maybe??
Give some details about how those sheets are laid out and what data
you have in them, together with a clearer explanation of what you are trying to do. Pete On Jun 23, 10:46*pm, Mary C (donotspam) wrote: I have 2 differant spreadsheets and need to find matching data on them. *What would I use to do it and how? TIA -- Mary C |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Maybe??
Sorry,
First Spreadsheet Column A 5050142552 8704046547 9902863308 5052020251 2599090534 8702794441 5000401686 8702007687 Second Spreadsheet1 Column A 5050142552 9902863308 5052020251 8702794441 5000401686 8702448016 5052084935 I need to create a column on Spreadsheet 1 to match the numbers from speadsheet 1 and spreadsheet 2. -- Mary C "Pete_UK" wrote: Give some details about how those sheets are laid out and what data you have in them, together with a clearer explanation of what you are trying to do. Pete On Jun 23, 10:46 pm, Mary C (donotspam) wrote: I have 2 differant spreadsheets and need to find matching data on them. What would I use to do it and how? TIA -- Mary C |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Maybe??
Put this in B1 of Sheet1:
=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"not in list 2","present in list 2") then copy the formula down by double-clicking the fill handle (the small black square in the bottom right corner of the cursor) with B1 selected. It will tell you if the number is present in the second list or not. Hope this helps. Pete On Jun 23, 11:09*pm, Mary C (donotspam) wrote: Sorry, First Spreadsheet Column A 5050142552 8704046547 9902863308 5052020251 2599090534 8702794441 5000401686 8702007687 Second Spreadsheet1 Column A 5050142552 9902863308 5052020251 8702794441 5000401686 8702448016 5052084935 I need to create a column on Spreadsheet 1 to match the numbers from speadsheet 1 and spreadsheet 2. -- Mary C "Pete_UK" wrote: Give some details about how those sheets are laid out and what data you have in them, together with a clearer explanation of what you are trying to do. Pete On Jun 23, 10:46 pm, Mary C (donotspam) wrote: I have 2 differant spreadsheets and need to find matching data on them. *What would I use to do it and how? TIA -- Mary C- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Maybe??
Thanks Pete that worked. I appreciate it.
-- Mary C "Pete_UK" wrote: Put this in B1 of Sheet1: =IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"not in list 2","present in list 2") then copy the formula down by double-clicking the fill handle (the small black square in the bottom right corner of the cursor) with B1 selected. It will tell you if the number is present in the second list or not. Hope this helps. Pete On Jun 23, 11:09 pm, Mary C (donotspam) wrote: Sorry, First Spreadsheet Column A 5050142552 8704046547 9902863308 5052020251 2599090534 8702794441 5000401686 8702007687 Second Spreadsheet1 Column A 5050142552 9902863308 5052020251 8702794441 5000401686 8702448016 5052084935 I need to create a column on Spreadsheet 1 to match the numbers from speadsheet 1 and spreadsheet 2. -- Mary C "Pete_UK" wrote: Give some details about how those sheets are laid out and what data you have in them, together with a clearer explanation of what you are trying to do. Pete On Jun 23, 10:46 pm, Mary C (donotspam) wrote: I have 2 differant spreadsheets and need to find matching data on them. What would I use to do it and how? TIA -- Mary C- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Maybe??
You're welcome, Mary - glad to hear it worked for you.
Of course, you could put a similar formula in Sheet2 to see if there are any values in there that are not in Sheet1. You can also apply autofilter to column B to enable you to focus in on those values present or not present. Pete On Jun 24, 2:54*pm, Mary C (donotspam) wrote: Thanks Pete that worked. *I appreciate it. -- Mary C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |