Jlamarre
New member
- Joined
- Nov 29, 2018
- Messages
- 22
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hello, this might be related to a problem in this thread.
I read somewhere that a vlookup might be slower then a index/match formula. But for the life of me I can't get it working. (even my vlookup on the information I read looking for does not work). No idea why.
Now my file is sheet1 (a table) that will gather information from other sheets in the same folder. The other sheets are getting theire information from an Sql query. So in each of the other sheets I have a copy of the sql table. (is this the best setup?)
Should I use index/match instead of vlookup?
My file hangs often. That's what I'm trying to resolve.
Thanks
Jl
Sent from my SM-G955W using Tapatalk
I read somewhere that a vlookup might be slower then a index/match formula. But for the life of me I can't get it working. (even my vlookup on the information I read looking for does not work). No idea why.
Now my file is sheet1 (a table) that will gather information from other sheets in the same folder. The other sheets are getting theire information from an Sql query. So in each of the other sheets I have a copy of the sql table. (is this the best setup?)
Should I use index/match instead of vlookup?
My file hangs often. That's what I'm trying to resolve.
Thanks
Jl
Sent from my SM-G955W using Tapatalk
Last edited by a moderator: