for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

larkim May 2023 1:51pm, 18 May 2023 21,133 posts	Quote Pin larkim You can omit the column number if you're using as a VLOOKUP as there's only one column to return. Ah, thanks - the tutorial page I was refreshing myself on used the whole array in the first index, but I should have remembered the single column approach!
SPR May 2023 2:02pm, 18 May 2023 40,562 posts	Quote Pin SPR Yes, once you're using the single column approach, it's not all that complicated and then you have all the advantages of never having to change the source data to get your lookups to work.
run free May 2023 5:41pm, 18 May 2023 5,289 posts	Quote Pin run free At the same time I prefer to use Power Query to pull data from one table into another. It is easy peasey compared to Index/Match and doesn't have the limitations as the Vile Lookup
GlennR May 2023 10:20pm, 18 May 2023 70,319 posts	Quote Pin GlennR My finance team are challenged by a SUMIF(). Power Query would give them the a fit of the vapours.
run free May 2023 11:49pm, 18 May 2023 5,292 posts	Quote Pin run free I bet they would love power query cos just need to learn to point and click 😍
GlennR May 2023 12:21am, 19 May 2023 70,329 posts	Quote Pin GlennR Goodness run free. You have no idea.
SPR May 2023 9:34am, 19 May 2023 40,565 posts	Quote Pin SPR Point and click without understanding is extremely dangerous, lol.
run free May 2023 10:42am, 19 May 2023 5,293 posts	Quote Pin run free GlennR I may not know yr people but I have taught enough people to know they find formulas harder to understand compared to point and click. Following a process seems to be easier to understand compared to understanding the parts of a formula And spr there are plenty of people making incorrect calculations becos they don’t understand the formulas they are using. They simply see that it has output a value so assume it is correct
SPR May 2023 11:22am, 19 May 2023 40,566 posts	Quote Pin SPR Possibly runfree, but having those same people point and click is a recipe for disaster.
SPR May 2023 11:23am, 19 May 2023 40,567 posts	Quote Pin SPR Now if someone else is reviewing the process and telling them what to do, it's different but not sure those same people can come up with the correct process in the first place.