Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

Find and Offset

Hi,

Can i have some formula or code that will loop down Column O and find "Grand Total" and then return the offset (0,3)

Thanks
Seamus
SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Seamus2626
Seamus2626
Flag of Ireland image

ASKER

Thanks guys
Avatar of redmondb
redmondb
Flag of Afghanistan image
Thanks, Seamus2626.
Avatar of Seamus2626
Seamus2626
Flag of Ireland image

ASKER

Just trying to link that through a different sheet and getting an error

='Top 20 B Pools - GLA Wealth'!OFFSET($O$1,MATCH("Grand Total",O:O,0)-1,2)

Can you amend the syntax?

Thanks
Seamus
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image
=OFFSET('Top 20 B Pools - GLA Wealth'!$O$1,MATCH("Grand Total",'Top 20 B Pools - GLA Wealth'!O:O,0)-1,2)
Avatar of Seamus2626
Seamus2626
Flag of Ireland image

ASKER

Thankyou ssaqibh