get row and column numbers
Hi,
I have a table of values in Excel and I used VLookUp to
get to a certain cell in the table. I am trying to write a
function that will sum up the value in the chosen cell (I
chose this cell using VLookUp) and the cell value directly
under the chosen cell.
I am assuming I need to first get the cell address of the
chosen cell and then use "Offset" to select the cell under
it but I do not know how to get the cell address of the
chosen cell. Can you help?
|