Hi All,

I have workbook with 2 sheets, sheet1 & sheet2.
sheet1 data as follows:
Group Id Code Status
125 ABC_DE completed
127 ACD_EF completed
130 ERD478 completed
131 EREDS completed


sheet2
Codes Status
ABC_D
ACD
ERD478
EREDS


By observation u can say only ERD478 & EREDS is exactly matching so i
want the status of that particular code.


Result 1 : Assume sheet1 has ABC as code, in sheet2 I have ABCDEF -
here in this case only part matching
here also i want the status.


Result 2 : If i want to match both Group Id and Code ( assumed sheet2
has Group Id).


Result 3 : If i want to match Codes ( sheet2 ) with Group Id & Codes
of sheet1. ( assumed some codes are appeared in Group Id)


All the above results,I want in VBA.


Thanks in advance.

Hi
No idea what you want. Re-read Result2 and Result 3 in your mail. Do
they ask a clear question???
regards
Paul

On Mar 6, 7:55*am, wrote:
Hi All,

I have workbook with 2 sheets, sheet1 & sheet2.
sheet1 data as follows:
Group Id * *Code * * Status
125 * * * ABC_DE * completed
127 * * * ACD_EF * completed
130 * * * ERD478 * *completed
131 * * * EREDS * * completed

sheet2
Codes * *Status
ABC_D
ACD
ERD478
EREDS

By observation u can say only ERD478 & EREDS is exactly matching so i
want the status of that particular code.

Result 1 : Assume sheet1 has ABC as code, in sheet2 I have ABCDEF -
here in this case only part matching
here also i want the status.

Result 2 : If i want to match both Group Id and Code ( assumed sheet2
has Group Id).

Result 3 : If i want to match Codes ( sheet2 ) *with Group Id & Codes
of sheet1. ( assumed some codes are appeared in Group Id)

All the above results,I want in VBA.

Thanks in advance.

Result 2 : Sheet 1 has group id , Code, status
Sheet 2 has group id , code, and i want to match group
id and code with sheet1's group id and code.

Result 3: sheet 1 has group id, code , status
sheet 2 has code, I want to match code with sheet2.


On Mar 6, 2:40*pm, wrote:
Hi
No idea what you want. Re-read Result2 and Result 3 in your mail. Do
they ask a clear question???
regards
Paul

On Mar 6, 7:55*am, wrote:



Hi All,

I have workbook with 2 sheets, sheet1 & sheet2.
sheet1 data as follows:
Group Id * *Code * * Status
125 * * * ABC_DE * completed
127 * * * ACD_EF * completed
130 * * * ERD478 * *completed
131 * * * EREDS * * completed

sheet2
Codes * *Status
ABC_D
ACD
ERD478
EREDS

By observation u can say only ERD478 & EREDS is exactly matching so i
want the status of that particular code.

Result 1 : Assume sheet1 has ABC as code, in sheet2 I have ABCDEF -
here in this case only part matching
here also i want the status.

Result 2 : If i want to match both Group Id and Code ( assumed sheet2
has Group Id).

Result 3 : If i want to match Codes ( sheet2 ) *with Group Id & Codes
of sheet1. ( assumed some codes are appeared in Group Id)

All the above results,I want in VBA.

Thanks in advance.- Hide quoted text -

- Show quoted text -