Hello
I have a working formula but I now want to use it to search across a large dataset so I really need to optimize the formula.
the formula is like this,
Ref Name Height Strength Weight 1 A 150 120 60 2 B 150 120 60 3 C 110 10 60 4 D 180 200 80
so when i use table, searching for Height, by Ref number I get the answer I want perfectly. but
when I am using with Really Really large data, it's really slowing me down. is there any kind of VBA code , or just excel formula i can make this process faster.
its keep lagging down,
the formula was like this.
=index([Height],match([Ref],Search cell number)
please help thanks all for reading my post
Bookmarks