Next function?

[John Keturi]

I have a cell which uses the "VLOOKUP" function. Is there a way I could
assign a macro to a cmd button, which would search for the next occurance of
the "lookup value", and then refresh or display it in the same or a
different cell?

 

[Tom Ogilvy]

Look in Excel VBA helps for the FindNext command. Look at the code example.
This will show you how to find multiple instances of a search term.