Hii I Have this Data and need your help
Agent ID Name skill SHIFT
6542 Syed Jamal 322 BA-(0900-1700)
6111 Johnson 987 BA-(1500-2300)
6116 Haroon 322 BA-(0900-1700)
5691 Youvraaj 322 BA-(1500-2300)
I want to extract data from AGENT ID with two criteria
Criteria 1) Match Skill 322
Criteria 2) Match Shift BA-(0900-1700)
How to get agent ID which match 322 and BA-(0900-1700) from given data with Index match Formula ??
Can Anyone help me in this regard???
bundle of thank in advance
![]()
Bookmarks