OFFSET Problems
Sounds liek you might want
=OFFSET((ADDRESS(ROW(O2),MATCH(O2,A2:K2,0),,false) ,0,2)
Else, you're moving one row down...
"John V" wrote:
Here is a formula which returns an error message:
=OFFSET((ADDRESS(ROW(O2),MATCH(O2,A2:K2,0),,false) ,1,2)
I am trying to return the value of a cell two columns over from where it
found the MATCH. The MATCH function works, as does the ROW and ADDRESS
functions. But when I add the OFFSET portion, I get the generic error message.
Any help or alternate approaches appreciated.
|