Awesome it worked. Thank a lot.

@ExcelDose

Ай бұрын

Glad to hear 🙏😎 hope you have subscribed to our channel

Great video 👍🏻😊very helpful . Didn't know about xlookup...will try this...

@ExcelDose

3 жыл бұрын

Cool, thank you 🙏🏼

Loving this! 😍

@ExcelDose

3 жыл бұрын

Thank you 😊

nice channel Lem Mortis

@ExcelDose

3 жыл бұрын

Thank you 😊

Amazing like always...

@ExcelDose

3 жыл бұрын

Thank you 😊

Just for information, the first approach takes a long time for the spreadsheet to calculate if you have a large dataset (in my case, two columns, 400 rows took about two minutes to calculate on a 2 GHz Dual-Core Intel Core i7 processor). Have not tested the second approach.

@ExcelDose

2 жыл бұрын

Thank you for doing testing, we haven’t done for this much huge data

Great video, any pros and cons of eacj method? When should either or be used or not used?

@ExcelDose

3 жыл бұрын

Thank you 🙏🏼 You can use these methods when you want to get based on multiple criteria. As of now we couldn’t found any pros and cons but will let you know if found.