Hi All,
I have a spreadsheet with a set of arrays that lookup two sets of information to find the matching data, but it is very laggy is there anything I can do to speed it up??
I have attached the sheet and highlighted in Yellow the relevant fields![]()
=IFERROR(INDEX('All Concessions'!$F:$F,MATCH(1,('All Concessions'!$B:$B=$B8)*(E$3='All Concessions'!$E:$E),0)),"")
Many thanks for any input
Danny
Bookmarks