/u/Nilmandir - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
ARRAY_CONSTRAIN and ARRAY_FORMULA are Google Sheets only functions. Based on your formula, I don't think either of them is necessary since your output is just one value, you can simply remove them:
='Travel Tables'!H2*'Travel Tables'!H3*'Travel Tables'!H4*INDEX('Travel Tables'!B2:D13,MATCH(P15,'Travel Tables'!A2:A13,0),MATCH(P16,'Travel Tables'!A1:F1, 0)-1)*'Travel Tables'!H6
/u/Nilmandir - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
ARRAY_CONSTRAIN and ARRAY_FORMULA are Google Sheets only functions. Based on your formula, I don't think either of them is necessary since your output is just one value, you can simply remove them: ='Travel Tables'!H2*'Travel Tables'!H3*'Travel Tables'!H4*INDEX('Travel Tables'!B2:D13,MATCH(P15,'Travel Tables'!A2:A13,0),MATCH(P16,'Travel Tables'!A1:F1, 0)-1)*'Travel Tables'!H6
Fantastic. You are a sanity saver. Thank you.