Index match for Offset Lookup data and Reference data

[pavanbhoyar]

Hello,
Attached is the file for the reference.
There is a offset in Lookup data array and reference data array.
Seeking for lookup function to fetch the data.

Thanks and Best Regards,
Pavan

[Czeslaw]

I propose the following formula.

Please Login or Register  to view this content.

[Czeslaw]

With LOOKUP.

Please Login or Register  to view this content.

[pavanbhoyar]

Thank you both of you..!!

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.