Hello everyone, I'm new to the forum so please don't be to harsh
Here is my question, is there a way to get 2 conditions in lookup formula, I tried a lot of stuff, INDEX/MATCH array formula, vlookup, IF and few more i can't even remember now. Since i'm not a native english speaker i will put a table here so it
might be easier to understand.
What i would like to be done automatically is: in sheet2 C2 copy a name of engineer from Sheet1, if date and shift are the same on Sheet1 and Sheet2.
Any ideas?
Bookmarks