Hello!
I have a sheet with a high number of cells (upwards of 200) referencing another sheet to pull information. It's for work, so the sheet where the information is stored has an employee's name, then metrics off in columns to the right. The way I've been doing things is to have VLOOKUP functions in cells to find the employee name and then the corresponding column I want info from. These forms take quite a while to update as a result.
I read online that INDEX/MATCH paired together was a faster option, so I took the time to build out a new sheet using that instead of VLOOKUP. The formula being used is this:
=INDEX('[Document1.xlsx]Sheet1'!$C:$C,MATCH($H$1,'[Document1.xlsx]Sheet1'!$B:$B,0))
I'm referencing entire columns instead of a specific range to allow for the option to move things around and not have things break. Would referencing the entire column instead of a range make things that much slower?
And is there a better way to accomplish what I'm trying to do? I ultimately just want Excel to go to Document1, find the person's name in a column, then return a value from the column of my choosing. I'm open to doing this in whatever way is fastest, and I could use any kind of help anyone's willing to offer.
Thanks!
Bookmarks