To collect an employee name in third sheet after checking employee code from 2 other sheets
Hi,
I want to pull an employee name (under column 'Employee Name') in current sheet named 'PQR'. Now, this employee name could be mentioned in sheet 1 named 'ABC' OR in sheet 2 named 'XYZ' under same column 'Employee name'. Sheet 1 and Sheet 2 have same column formats and names.
The condition here is to match employee code in PQR with that in ABC and XYZ. If the code is found in any of these 2 sheets, return the employee name for that particular code.
Currently, I am using Index and match function to extract employee name from 1 sheet, ABC. How to do that with OR function for 2 sheets? Or if there is any other way?
Current formula:
=INDEX({ABC Employee Name}, MATCH([PQR Employee Code]@row, {ABC Employee Code}, 0))
Best Answer
-
You would write out another INDEX/MATCH for sheet 2 and then join them together with an IFERROR.
=IFERROR(1st_index_match, 2nd_index_match)
Answers
-
You would write out another INDEX/MATCH for sheet 2 and then join them together with an IFERROR.
=IFERROR(1st_index_match, 2nd_index_match)
-
Thank you, that resolved it!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!