Related Posts
How much should a shift lead make west coast
Hi please give me likes to start DM
What are thoughts on leaving in January?
Anyone familiar with or us Snappy Kracken?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.



Python > excel
Filtering for exactly the value you are looking for and then copying and pasting the value for max time efficiency >>>>>>>>>
Hard coding is devil 😫🤓
Always
Lmao yeah if you use anything other than index match match ngmi
Xlookup is quicker to construct and more readable especially if you use the iferror parameter
Don’t forget to use protection, “IfErroror”
Freezing cold take
Yup, errors happen with xlookup, index match match is more robust in my experience
Agreed, I've had so much more lost time recovered from switching to idx just based on the frequency of errors alone
Alright I’m a daily user of index match, but what is this second match you’re bringing in??
Nope
idx match way better but time consuming
zlookup
I'm sorry, I'm not sure I understand what you are trying to say.