VBA to lookup for a specific value and give result

I Have a workbook with 2 sheets " Acct. Details" and "Manual Checking"
In sheet "Manual Checking" have a column F (UTR NO.2) which contains digits.

Check the same digits in Sheet "Acct. Details" in column C (Particulars).
If string in C of Sheet "Acct. Details" contains the Digits of Column F of Sheet "Manual Checking" then in column "I" in "Manual Checking" should show SR. no. (Column D) from Acct Details.
If the digits are not exists the result should be "No Sr."

For example please refer sheet "Result Needed". Required result marked in grey colour

Maybe:

Please Login or Register  to view this content.

Hi, Its working, but it not working on duplicate entries

There are some number from sheet "Manual Checking" in a column F (UTR NO.2) which contains digits. has multiple records in Sheet "Acct. Details" in column C (Particulars).

If there is more than one entry the SR number should be more than one and should be seprated by "^". Please refer attachment sheet "result needed", example marked in Orange colour

For an example:

The number "299463012" in Column F of sheet "Manual Checking" contains in column C of sheet "ACCT. DETAILS" for 2 times hence the SR number is "5385^4888"

The number "26260857" in Column F of sheet "Manual Checking" contains in column C of sheet "ACCT. DETAILS" for 3 times hence the SR number is "1766^4211^9089"

can you please change the code accordingly?

Try:

Please Login or Register  to view this content.

winmaxservices

The results are bit different...

Please Login or Register  to view this content.

do i mis something or is there a reasen ?

row 52 Nr 15299483 in your sheet needed result = 6037

but rows 38,43 en 47 have also Nr 15299483 in column C


Kind regards
Leo

Hi, Your code works perfectly.
I am new to VBA. Can you please explain the code that how it works? means functions of each line by line. Just for my knowledge.

Thanks

Hi, I checked the code. But it is not working for few cells.

Please find attached workbook.
in Sheet Manual Checking Cell "I7" should show 30303, but shows only 303. Because SRL No.in sheet "ACCT.DETAILS is 30303
in Sheet Manual Checking Cell "I8" should show 28282, but shows only 282. Because SRL No.in sheet "ACCT.DETAILS is 28282

Can you please check and revert with changes in code