Hello,
I have been assigned an urgent task this morning and would need some help.
I have a huge table as show below;Attachment 633127
I would like to amend asAttachment 633128
I am actually placing the connection into a column and fill the correspondent details, buy using Index Match function =INDEX(FCB[depdesc],MATCH(1,(A3=FCB[code])*($D$2=FCB[source]),0) with CSE but since table contains about 150,000 row it's taking ages to complete.
Any suggestion or ideas how I could speed and improve?
Thanks in advance
Bookmarks