I have two tabs;
Tab 1 = Results
- B = List of names
- D = Course taken
- E = Result
Tab 2 = Key Names
- K = list of names
I need Tab 2 column L to insert the Result (E) on the conditions;
- That the names match (TAB 1, B, MATCH TAB 2, K)
- They have taken X course (D)
So IF TAB 1, B MATCHES TAB 2, K, AND THEY HAVE TAKEN 'X' COURSE, INSERT RESULT, E.
Can someone please advise on code, thanks!
Aucun commentaire:
Enregistrer un commentaire