Next function?
 

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?

Next function?
 

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.

--
Regards,
Tom Ogilvy

"John Keturi" wrote in message
news:q7Gbd.28479$hj.25638@fed1read07...
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?