| Home |
| Search |
| Today's Posts |
|
#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 - |
| 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 | |||
![Mary C[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
