Apply the offset formula in Name range

[sachar]

Dear,

With reference to the attached sample file, may I know, how can I apply the OFFSET formula on name “range”

Thanking you,

 

[Deepak]

Is this...

=OFFSET(BASE_FIGURE!$A$1,,,LOOKUP(2,1/(BASE_FIGURE!$D$1:$D$1111<>""),ROW($D$1:$D$1111)),3)

 

[sachar]

Dear,

Thanks to received the reply, the above formula is not working properly because it has returned the value, although, there is no Account code in Column A., and the main purpose is to update the “Resort Div. TB” worksheet in case introduces any new account in “Base_Figure” worksheet with help of Name Manager.

Thanking you

 

[Deepak]

What i have posted is based on the input range in your uploaded file.
Will you pls upload a new wb highlighting what you said.

 

[Somendra Misra]

Hi,

Try this one:

=OFFSET(BASE_FIGURE!$A$1,MATCH("Account Code",BASE_FIGURE!$A:$A,0),,MATCH(99^99,BASE_FIGURE!$A:$A),3)

Regards,