Can anyone tell me what Formula I would need to do the below.
Cell A1 has ULKY5010 then G1 shows Joe Bloggs.
Basically I have a list of 6 names and various Project Numbers, depending what Project Number is shown in A4 will depend what name is shown in G4, or would a lookup be better.
Please see attached.
Can anyone help at all?
Shazz
x
Cell A1 has ULKY5010 then G1 shows Joe Bloggs.
Basically I have a list of 6 names and various Project Numbers, depending what Project Number is shown in A4 will depend what name is shown in G4, or would a lookup be better.
Please see attached.
Can anyone help at all?
Shazz
x