How To Use XLOOKUP With Multiple Criteria

[@How_2_Excel]

Here is the link to the file if you want to follow along.
1drv.ms/f/s!AkFFIE88DTrqiXWnPkM6Qphydyig?e=Qqpf9R

[@Happytolearn399]

Awesome, great help!

[@TheAlwaysGoel]

Great buddy loves from india

[@How_2_Excel]

Thanks for the kind comment! ☺️

[@dakshbhatnagar]

Lovely!!

[@How_2_Excel]

Glad you like it

[@andrewzhauoo4664]

great boss, so helpful

[@How_2_Excel]

Awesome, glad to hear it, thank you ☺️

[@shekonimusbaudeen3671]

Brilliant video. Thanks Dave!

[@How_2_Excel]

You’re welcome, glad you liked it. ☺️

[@mohammadzeeshan992]

The second method is very impressive and logical.

[@How_2_Excel]

Thank you, glad you like it

[@manjit.sarania]

Sir ur teaching is great but data and formula is not seen clearly to learn

[@anand120556]

You dont even need xlookup. Multiply the the value column with true test column.

[@How_2_Excel]

Lots of various ways to do the same thing 👍🏼