How to do an Excel Xlookup

[@AzamKhan-pq3vq]

How to check total sales of product region wise using this

[@Rice0987]

Thank you, good girl.🤗

[@XecuteTheVision]

😀

[@parahiamin6765]

Would XLOOKUP be faster than SUMIFS?

[@XecuteTheVision]

Good point, haven’t tried that one for this

[@jameszimmerman4695]

Ooh... Nice!

[@XecuteTheVision]

Glad it’s helpful!

[@carloscrespo-riera9815]

Why don't you use Validation lists for the Company and Region so you do not need to type them.

[@XecuteTheVision]

Good idea!

[@driftingdandelion]

no

[@XecuteTheVision]

?