How to lookup Values Using XLOOKUP and INDIRECT!

[@MrJorgeemh]

Super helpful thanks for sharing your knowledge

[@ExcelWithAnser]

It's my pleasure!

[@amandalow1065]

Very clear and concise, thank you!!

[@ExcelWithAnser]

You're welcome!

[@evolutionclouds]

Thank you so much for that! That was exactly what I needed! I do have one question Let’s say the tables include another column Can I create a data validation that filters a list by more than one criteria?

[@ExcelWithAnser]

Hi there, In the second argument of the XLOOKUP function (Lookup Array), you can add and "&" function if you want to use multiple columns as your condition, and then in the 3rd argument of XLOOKUP, you can refer to the return array, whichever column that may be. I hope that helps. Feel free to let me know if you need further explanation!