Loop with lookup on first match

I found a thread for a loop function that works like vlookup (thank you for the code, MickG). This code finds every match in the lookup range, but I only want it to find the first match and then loop to the next value to look up. Here is the code:

Please Login or Register  to view this content.

When the value from the first cell in Rng is found in the oDat range, I want it to execute the code on that cell in the oDat range and then loop back to the second cell in Rng and execute the code on the first value it finds in the oDat range, etc. This code finds every match from the first cell in Rng in the oDat range and executes the code on every match.

Thank you in advance for your help.

Hello
Why not use a VLOOKUP if you want to find the first in a colmn?
Regards
Peter