Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
get row and column numbers
John,
I think you need Match and Index. You get the value off the cell by VLOOKUP, and say you store that value in A1, and the column looked into was G1:G20, then you use =INDEX(G1:G20,MATCH(A1,G1:G20,0)+1) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "JohnZim" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing A Column Of Text numbers To True Numbers: How ? | New Users to Excel | |||
How do I convert a column of positive numbers to negitive numbers | Excel Worksheet Functions | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Changing column of numbers made of formulas to just numbers | Excel Discussion (Misc queries) | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions |