I'm trying to convert my templates from google sheets to zoho sheets, however when I did so all my formulas in the template seems to be broken and can't seem to have it work when I just type in the formula on zoho.

The formula I usually used is Index, Match which would look up from one sheet to another.

Could anyone here assist me in writing the formula to zoho sheets. Sample formula I used on google sheets: =IF(B2="Elizabeth", INDEX(Sheet1!B2:B10),MATCH("Elizabeth",Sheet1!A2:A10) please help me re-write this formula that apply to zoho sheets.

Thank you.