| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
active cell
trying to find a way to vlookup with the "lookup_value" reference for the
column being absolute and the reference for the row being the active cell based on where-ever the cursor is. any change in cursor position should be reflected in real-time in the vlookup formula display - does anyone know if this is possible? thanks... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
active cell
=VLOOKUP(INDIRECT("B"&CELL("row")),Sheet2!$M$1:$P$ 200,4,FALSE)
However, this only changes the result when a calculation occurs and changing the activecell does not cause a calculation to occur. But if you click different cells and hit F9, you will see it works at least to that extent. -- Regards, Tom Ogilvy "John Carroll" wrote in message ... trying to find a way to vlookup with the "lookup_value" reference for the column being absolute and the reference for the row being the active cell based on where-ever the cursor is. any change in cursor position should be reflected in real-time in the vlookup formula display - does anyone know if this is possible? thanks... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
active cell
Thanks very much - that works great!
"Tom Ogilvy" wrote: =VLOOKUP(INDIRECT("B"&CELL("row")),Sheet2!$M$1:$P$ 200,4,FALSE) However, this only changes the result when a calculation occurs and changing the activecell does not cause a calculation to occur. But if you click different cells and hit F9, you will see it works at least to that extent. -- Regards, Tom Ogilvy "John Carroll" wrote in message ... trying to find a way to vlookup with the "lookup_value" reference for the column being absolute and the reference for the row being the active cell based on where-ever the cursor is. any change in cursor position should be reflected in real-time in the vlookup formula display - does anyone know if this is possible? thanks... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| set the background color of the current cell(active cell) | New Users to Excel | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| find text in a cell and make cell 2 cells below that active | Excel Programming | |||
| Select First Active Cell if the cell is in a pivot table | Excel Programming | |||
Linear Mode
