index formula

[pillr001]

Hi Guys,

i've got the below forumula working on google sheets, just to need get it to work on excel if possible https://docs.google.com/spreadsheets/d/11PW7jopnfnlqsgEMlTz_UxXzlJczV6q7PFHqxKKIxU8/edit#gid=0

below is the formula for sheets, how would you transfer this into excel
=ArrayFormula(IFERROR(VLOOKUP(ArrayFormula(P30&N32:N),{ArrayFormula(T31:T130&U31:U130),V31:X130},{2,3,4},False)))

Would anyone be able to advise>?

 

[pillr001]

Re: index formula help

Can anyone help please, below is a screen shot of the spreadsheet.

<a href="https://imgbb.com/"><img src="https://i.ibb.co/q5Z9nfB/SPECIAL-OFFER.png" alt="SPECIAL-OFFER" border="0"></a>​