Offset formula

[sachar]

Dear Troubleshooter,

With reference to the attachment, applied the following formula in column “F” (LOCATION) and [/QUOTE] the range with bold* color, my question is, can we use the OFFSET formula to create dynamic range that is fed in formula?


=IFERROR(INDEX(RECONCIL!$F$5:

$F$3030*,

(MATCH('BASEDATA(Rev)'!A4,RECONCIL!$A$5:

$A$3030*

,0))),0)

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan