I am attempting to look up data on sheet 'Data2' based on the 'username' on sheet 'Data1'...but I only want to return the data from sheet Data2 if the data contains the word 'written.' I am not sure how to go about this...either VLOOKUP or MATCH? I'm not sure how to make this happen.
I see that "INCIDENT DATE" is in column E of Data2. Where in Data2 is "ACTIVE DISCIPLINES; COACHING"?
Also, what if there are multiple incidences for the same username? Do you only want to pull one of them into Data1?
It would help to see some desired results based on the sample data.
Last edited by 63falcondude; 07-11-2018 at 02:08 PM.
So on sheet Data1, if username Sharmon2 appears on Data2, column D (incident type) contains 'written', I want that to return to cell C7. I only need to pull one of the warnings, so multiples won't matter.
Try these:
C7 =IFERROR(INDEX(Data2!D$2:D$208,MATCH(1,(Data2!A$2:A$208=B7)*(ISNUMBER(SEARCH("written",Data2!D$2:D$208))),0)),"") Ctrl Shift Enter
D7 =IFERROR(INDEX(Data2!F$2:F$208,MATCH(1,(Data2!A$2:A$208=B7)*(ISNUMBER(SEARCH("written",Data2!D$2:D$208))),0)),"") Ctrl Shift Enter
Seems to be working; thank you so much!!!!
You're welcome. Happy to help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks