Found this video as I was looking for something for Index and match, the whole thing is so confusing as I am doing an excel challenge and yes, there are examples...lol but I am asking myself what determines the variables you are supposed to use from the given data you have?... and I am not even sure if this is the right question I should be asking myself in the first place. The X-look up function on the other hand, does seem really easier to use and I am glad I landed on this.
@ShemOpolot Жыл бұрын
I'm not sure if there's still a question here, Elizabeth 😂. But, if you email me, we can chat about your concerns with INDEX/MATCH. Otherwise, yes, for the most part, if you have an updated version of Excel, XLOOKUP is MUCH better.