ammykhan
Board Regular
- Joined
- Apr 23, 2022
- Messages
- 55
- Office Version
- 2021
- Platform
- Windows
Hey All friends
,
Can I get suggestion how to combine two lookup functions, I have a situation where I have to lookup customer data using their employee id but some customer forgets to give their details in such a scenario I need to filter the data by making use of their name instead. Want to make a combined formula to filter data by using either their Name or Employee Id, is there a way to combine two lookup functions for keeping our Excel sheet simple. The formula I'm trying to build shall be more or less like the one below.
=OR(XLOOKUP($D2,Staff_no, Location), XLOOKUP($D2,Name, Location)
Any advice from my senior fellows will be highly appreciated so I can further my insight in MS Excel, thanks in advance![Smiling face :relaxed: âşď¸](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/263a.png)
![Waving hand :wave: đ](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f44b.png)
Can I get suggestion how to combine two lookup functions, I have a situation where I have to lookup customer data using their employee id but some customer forgets to give their details in such a scenario I need to filter the data by making use of their name instead. Want to make a combined formula to filter data by using either their Name or Employee Id, is there a way to combine two lookup functions for keeping our Excel sheet simple. The formula I'm trying to build shall be more or less like the one below.
=OR(XLOOKUP($D2,Staff_no, Location), XLOOKUP($D2,Name, Location)
Any advice from my senior fellows will be highly appreciated so I can further my insight in MS Excel, thanks in advance
![Smiling face :relaxed: âşď¸](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/263a.png)