Hi All,
I'm trying to lookup an employee's name in an array and return the name of the department they are working in for that shift.
Their names are only part of the cell they are in so this becomes a little difficult. Also, I'm limited to this format, so I can't make improvements to the 'Sydney'! sheet which would help in this problem.
Please see the attached file.
The result I'm looking for is in the 'OT'! sheet
Thankyou for your assistance in advance.
AT
C5No so good, but still working!
=IF(ISERROR(MATCH(B5&"*",Sydney!C:C,0))=TRUE,IF(ISERROR(MATCH(B5&"*",Sydney!E:E,0))=TRUE,IF(ISERROR(MATCH(B5&"*",Sydney!G:G,0))=TRUE,IF(ISERROR(MATCH(B5&"*",Sydney!I:I,0))=TRUE,IF(ISERROR(MATCH(B5&"*",Sydney!K:K,0))=TRUE,IF(ISERROR(MATCH(B5&"*",Sydney!M:M,0))=TRUE,IF(ISERROR(MATCH(B5&"*",Sydney!O:O,0))=TRUE,"NO FIND",INDEX(Sydney!B:B,MATCH(B5&"*",Sydney!O:O,0))),INDEX(Sydney!B:B,MATCH(B5&"*",Sydney!M:M,0))),INDEX(Sydney!B:B,MATCH(B5&"*",Sydney!K:K,0))),INDEX(Sydney!B:B,MATCH(B5&"*",Sydney!I:I,0))),INDEX(Sydney!B:B,MATCH(B5&"*",Sydney!G:G,0))),INDEX(Sydney!B:B,MATCH(B5&"*",Sydney!E:E,0))),INDEX(Sydney!B:B,MATCH(B5&"*",Sydney!C:C,0)))
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Thats perfect wenqq3
Thank you so much
Welcome. Great is helped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks