Hi Guys,
I need to transfer this google sheets formula to excel formula is possible please.
https://docs.google.com/spreadsheets...xU8/edit#gid=0
=ArrayFormula(IFERROR(VLOOKUP(ArrayFormula(P30&N32:N),{ArrayFormula(T31:T130&U31:U130),V31:X130},{2,3,4},False)))
Would anyone be able to advise