Thread: OFFSET Problems
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John V[_2_] John V[_2_] is offline
external usenet poster
 
Posts: 33
Default OFFSET Problems

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.