Need a macro code for formula using both absolut and relative refe
I have a unique requirement to write a macro for a formula using both
absolute and relative reference. For example, VLOOKUP a relative cell and
lookup in an absolute reference table.
Appreciate any kind of help.
|