Can you update your Current Excel Version & Platform here as well as in your Profile. The solution will depend on that.View attachment 72856
Hello, I am trying to vlookup based on multiple criteria. Last name, first name, then looks up address on sheet 2.
Any thoughts?
Excel Version? 2016, 2019, 2021 ????Verzion 16.4
Are you using Mac OS or Windows?I am not sure on platform
macAre you using Mac OS or Windows?
Then XLOOKUP is the best bet2022 Mircosoft 365 I think