Formula works but cannot handle volume data ,
maybe the look up are too many
Maybe a macro can handle this ?
Formula works but cannot handle volume data ,
maybe the look up are too many
Maybe a macro can handle this ?
Use Helper column/cell to join the data which will work faster rather than joining inside the formula.
In K2 Cell of Sheet2
=A2&J2
Drag it down...
In D2 Cell of Sheet1
=IFERROR(INDEX(Sheet2!$D:$D,MATCH(Sheet1!$A2&Sheet1!D$1,Sheet2!$K:$K,0)),"")
Drag it down and right...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Yes thanks , nice one , seems this wont hang up
on long data
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks