I am hoping someone can guide me in the right Direction, I have got the basics of Vlookup, but want to take it a stage further
I have two sheets with identical entries in columns a - c
A= Organization Name
B = User Name
C = User Email
<tbody>
</tbody>
However the 2nd sheet has a column D with Certificate details, a standard Vlookup would work except sheet two has multiple entries for columns B&C
I want it to check the names for a match then find a specific value in D lets say "HPCert" and then put a complete to sheet 1 column D for HPCert
<tbody>
</tbody>
Can anyone advise, driving me mad
I have two sheets with identical entries in columns a - c
A= Organization Name
B = User Name
C = User Email
Organization Name | User Name | UserEmail | HPCertification |
Blue Label | Joe Bloggs | joeB@BlueLabel.org | |
Red Wolf | Dan Smith | DanS@Redwold.org |
<tbody>
</tbody>
However the 2nd sheet has a column D with Certificate details, a standard Vlookup would work except sheet two has multiple entries for columns B&C
I want it to check the names for a match then find a specific value in D lets say "HPCert" and then put a complete to sheet 1 column D for HPCert
Organization Name<strike></strike> | User Name<strike></strike> | UserEmail<strike></strike> | Certification<strike></strike> |
Blue Label<strike></strike> | Joe Bloggs<strike></strike> | joeB@BlueLabel.org<strike></strike> | HPCert |
Blue Label<strike></strike> | Joe Bloggs<strike></strike> | joeB@BlueLabel.org<strike></strike> | DellCert |
Blue Label<strike></strike> | Joe Bloggs<strike></strike> | joeB@BlueLabel.org<strike></strike> | AppleCert |
Red Wolf<strike></strike> | Dan Smith<strike></strike> | DanS@Redwold.org<strike></strike> | HPCert |
Red Wolf<strike></strike> | Dan Smith<strike></strike> | DanS@Redwold.org<strike></strike> | DellCert |
Red Wolf<strike></strike> | Dan Smith<strike></strike> | DanS@Redwold.org<strike></strike> | AppleCert |
Red Wolf<strike></strike> | Dan Smith<strike></strike> | DanS@Redwold.org<strike></strike> | CiscoCert |
Red Wolf<strike></strike> | Dan Smith<strike></strike> | DanS@Redwold.org<strike></strike> | AndroidCert |
<tbody>
</tbody>
Can anyone advise, driving me mad
Last edited: