Jump to cell address of Vlookup result

Hi all,

I'm trying to write code that that will help me jump to the cell address of a Vlookup result. For example:

- A Vlookup formula in cell A1 of Sheet1 references a table in Sheet2 and displays the contents of cell C10 of Sheet2.
- I want to be able to click on cell A1 of Sheet1, use a macro shortcut, and automatically jump to cell C10 of sheet2.

I've seen some similar posts, but these seem to be limited to specific tables/sheets. I want to be able to use the same VBA code on any Vlookup formula of any cell/sheet, and automatically jump to the cell that contains the result displayed by the Vlookup formula. I'm a novice coder and this is beyond me. Any ideas?

Thanks!

Thanks, I've seen similar formulas and they are helpful in specific circumstances. My real goal, however, is to have a quick/universal solution that I can use in any workbook without much effort. The use of the formulas take a bit of time so wouldn't fit that need in most circumstances. Would really need a programmatic solution.

I am trying to jump to a cell within a sheet itself with a look up value. This is what I want to do: Lookup lot number in column A3-160, and then jump to the line that corresponds to the lot number. How would this be accomplished with vlookup? Sorry, I haven't done anything in excel in a long time.