Want the range of a single cell in a range(column 7) where the value v has been found in the first column.
Posted on 2011-02-22
Given that I have a string v and a range rng, I want to lookup the value v in the range rng and return the range of the 7th column on the row the value v was found. I was able to use Applciation.VLOOKUP to return the value, but I need the range of the single cell, not the value.
The search column of the range rng for the value v will be the first column if that makes a difference.