ithoughtiknewit
New Member
- Joined
- Feb 11, 2021
- Messages
- 10
- Office Version
- 365
- Platform
- MacOS
Hi! I think this should be easier than I am making it. I have a list of customers and several employees visiting them. I then have the list of employees, and I want a formula to find where they are. There are often up to 6 that visit that client at a time so I need the search to be across B, C, D, etc. I have used XLOOKUP and it works great with just one search. For example, if I am looking for Jay and only search B, I use "=XLOOKUP(F2,B1:B4,A1:A4)". I am stuck searching more than B.