Hello,
I'm trying to do a vlookup of 2 conditions in a large range of data. For that I understand that the best way is to use an Index Match formula and then CTRL+SHIFT+ENTER. This works for one line, but when I drag down for the 10.000 lines, it is not finding the values that I know to exist. If I do F2 over one cell and do CTRL+SHIFT+ENTER, it works again, but how can I CTRL+SHIFT+ENTER for all the cells within the 10.000 lines?
Thank you in advance.
I'm trying to do a vlookup of 2 conditions in a large range of data. For that I understand that the best way is to use an Index Match formula and then CTRL+SHIFT+ENTER. This works for one line, but when I drag down for the 10.000 lines, it is not finding the values that I know to exist. If I do F2 over one cell and do CTRL+SHIFT+ENTER, it works again, but how can I CTRL+SHIFT+ENTER for all the cells within the 10.000 lines?
Thank you in advance.