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!

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!

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!

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 -