Macro to Scan table array for value from Cell, Value is not constant

Hi All,

So my issue is I am trying to use a macro to do a vlookup in for a cell value, if the cell value is found the sub can continue, if not, it will return a message to me. The cell value is not constant, so I can not use = "123" etc..

The cell in question is C25 on sheet "Template". The table array is on Sheet "Expat", C to BA & 3 till last row. So far I have been able to create a code that will check whether the value in C25 is equal to a specific value.

If the value is seen I will be adding more to it, but I can record that part.

Please Login or Register  to view this content.

My attempts to add a vlookup, failed..

Please Login or Register  to view this content.

Any guidance would be greatly appreciated.
Hope this is clear.
Thanks,
Luke

Thank you Leith for the attempt. I have not had time to play this again recently.

I will attempt again using the RC excel format.

Any more advice again would be greatly appreciated.
Thanks,
Luke