| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup between sheets, finding a match, and returning a letter
I'll do my best to explain. We have two sheets, 1 & 2, with matching column
headings in both. I need Excel to look through the thousands of ID numbers in sheet 1 column A, and look for a match in sheet 2 column A. We have thousands of ID numbers in both columns in both sheets. When it finds a match, we would like it to then put a "D" in all corresponding rows in sheet 1 in a blank column we created. So if it finds 4 records in sheet 1 column A and 4 in sheet 2 column A for ID #12345, we would like 4 a "D" to appear in a blank cell (column G) for each of the 4 matches in sheet 1. If no matches are found, we would like an "ND" to appear in each blank cell in column G, sheet 1. So if no match for ID #56789, we would like an "ND" to be placed in column G, sheet 1, for that record (on that row). I tried to explain this as detailed as possible...lol. Any help is appreciated as our deadline is upon us and we are stuck. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup between sheets, finding a match, and returning a letter
In Sheet1 G1 put this formula:
=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"ND","D") Copy this down as required. Hope this helps. Pete On Apr 11, 5:32*pm, CSmith wrote: I'll do my best to explain. *We have two sheets, 1 & 2, with matching column headings in both. *I need Excel to look through the thousands of ID numbers in sheet 1 column A, and look for a match in sheet 2 column A. *We have thousands of ID numbers in both columns in both sheets. *When it finds a match, we would like it to then put a "D" in all corresponding rows in sheet 1 in a blank column we created. *So if it finds 4 records in sheet 1 column A and 4 in sheet 2 column A for ID #12345, we would like 4 a "D" to appear in a blank cell (column G) for each of the 4 matches in sheet 1. *If no matches are found, we would like an "ND" to appear in each blank cell in column G, sheet 1. *So if no match for ID #56789, we would like an "ND" to be placed in column G, sheet 1, for that record (on that row). *I tried to explain this as detailed as possible...lol. *Any help is appreciated as our deadline is upon us and we are stuck. *Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup between sheets, finding a match, and returning a letter
It worked beautifully!! Thank you so much for your help, and quick at that!
I posted before lunch, and had your response when I returned! "Pete_UK" wrote: In Sheet1 G1 put this formula: =IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"ND","D") Copy this down as required. Hope this helps. Pete On Apr 11, 5:32 pm, CSmith wrote: I'll do my best to explain. We have two sheets, 1 & 2, with matching column headings in both. I need Excel to look through the thousands of ID numbers in sheet 1 column A, and look for a match in sheet 2 column A. We have thousands of ID numbers in both columns in both sheets. When it finds a match, we would like it to then put a "D" in all corresponding rows in sheet 1 in a blank column we created. So if it finds 4 records in sheet 1 column A and 4 in sheet 2 column A for ID #12345, we would like 4 a "D" to appear in a blank cell (column G) for each of the 4 matches in sheet 1. If no matches are found, we would like an "ND" to appear in each blank cell in column G, sheet 1. So if no match for ID #56789, we would like an "ND" to be placed in column G, sheet 1, for that record (on that row). I tried to explain this as detailed as possible...lol. Any help is appreciated as our deadline is upon us and we are stuck. Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup between sheets, finding a match, and returning a letter
Glad to be of help - thanks for feeding back.
You should meet your deadline now !! <bg Pete On Apr 11, 7:03*pm, CSmith wrote: It worked beautifully!! *Thank you so much for your help, and quick at that! * I posted before lunch, and had your response when I returned! "Pete_UK" wrote: In Sheet1 G1 put this formula: =IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"ND","D") Copy this down as required. Hope this helps. Pete On Apr 11, 5:32 pm, CSmith wrote: I'll do my best to explain. *We have two sheets, 1 & 2, with matching column headings in both. *I need Excel to look through the thousands of ID numbers in sheet 1 column A, and look for a match in sheet 2 column A. *We have thousands of ID numbers in both columns in both sheets. *When it finds a match, we would like it to then put a "D" in all corresponding rows in sheet 1 in a blank column we created. *So if it finds 4 records in sheet 1 column A and 4 in sheet 2 column A for ID #12345, we would like 4 a "D" to appear in a blank cell (column G) for each of the 4 matches in sheet 1. *If no matches are found, we would like an "ND" to appear in each blank cell in column G, sheet 1. *So if no match for ID #56789, we would like an "ND" to be placed in column G, sheet 1, for that record (on that row). *I tried to explain this as detailed as possible...lol. *Any help is appreciated as our deadline is upon us and we are stuck. *Thanks!- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to return next match of table, only finding first match...HEL | Excel Worksheet Functions | |||
| Excel returning more than one value from a lookup table that match the same value | Excel Discussion (Misc queries) | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| formula for returning the largest letter in a series of letters | Excel Worksheet Functions | |||
| Sum values in multiple sheets using Lookup to find a text match | Excel Worksheet Functions | |||
Hybrid Mode
