Vlookup returns a string. It doesn't return a reference to a cell. You can
use Match to return an offset into a range, then use that to select a cell.

--
Regards,
Tom Ogilvy

"Muusbreath" wrote in message
...
Is it possible to select all cells in a range with a particular formula,
for
instance, VLOOKUP?