Forum Discussion
Index and Match on multiple tabs
Hello guys, I need your expertise to get some help on the following: I have an xls sheet containing Account types information that has three tabs: - Page1 - Page2 - Summary I do paste informati...
I do not follow what you are doing but VLookup(target;table;col) is functionally equivalent to index(table;match(target;index(table;0;1);false);col). It is unlikely going to give you better performance unless you look up multiple values within the same result row, when a single MATCH will do, the row number of which can then be reused in multiple calls on INDEX.
- Hi ecovonrein and thanks for your reply.
What I basically need to do is to reduce the amount of resources my file is using by having around 1,800 cells that have vlookup formula on it.
Long story short: I need to get values from Page1 and Page2 that matches with a column name on page "summary".
Page1 and Page2 contains data pasted from other site, so those pages have different values every time we need to produce the matching info in "summary" tab.
Not sure if this is clear.
Please let me know if you have any other idea on how to figured out and thanks in advance.
