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...

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...

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...