active cell

[Guest]

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

 

[Tom Ogilvy]

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

 

[Guest]

Thanks very much - that works great!

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