Need VBA to find result from multiple condition range

HI experts

I have set of data need to get result from 2 set of range when met with lookup values

For E.g

IF Column A value met Inter System Billing I have billing key "ITB"in range G:H So result should ITB in C:C
IF Column B value met Mobile ACS SW Cloud Services - LAD (Inact.) i have billing key "ETB" in range J:K so result should ETB in C:C
rest of all blank cell should be result "COLLERATE_BILLING"


code should run on only blank value cell of C:C becoz data existed already

i want add criteria range in code itself becoz i run the code through multiple closed workbook's

find the attachment

can u help me on vba code?

Hello.
I leave the macro used.

Please Login or Register  to view this content.

However, and comparing with the expected result, I have differences in several rows, for example: 799 to 810.

.
I forgot to upload the workbook:

LOOKUP_CRITERIA_2.xlsm
\__________________________/

HI boss Thank for code its solved !! can i have critical range as array include in code, Becoz i run this code with sending mail vba, so if u can help me thanks alot

Originally Posted by breadwinner

HI boss Thank for code its solved !! can i have critical range as array include in code, Becoz i run this code with sending mail vba, so if u can help me thanks alot

I tell you this in case you haven't noticed yet that in posts #5 and #6 you can read:

This post has not received any reputation.

And that does not give too much desire to continue helping...