Problem with variable types in an index/match function

Hi,
I've been testing a piece of code but can only get it to work when I set my variables to string values and look up an alpha character. When I change my variable to integer and look for a number, I get a "Type Mismatch Error 13". It seems to have something to do with the "evaluate" formula, but not sure. Your suggestions are welcome.

Below are two versions of my code. FindABC() works, while Find123() gets an error. A test worksheet with these routines are also attached.
Many thanks!
Cesar

Please Login or Register  to view this content.

Thank you! Using .find is a much cleaner approach. However, can it be combined with a function to find the cell address in an adjacent column? What I was looking for was a function similar to Vlookup, but rather than bringing back a value from column C, I was looking for the address, hence the Cell/Index/Match mess I wrote.

Okay, I think I've solved it. By using the Offset feature I can get the address I'm looking for. Thanks again!

Please Login or Register  to view this content.