Formula for Conditional Formatting

[Shazz]

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

 

[PCosta87]

Hi,

I couldn't find "Joe Bloggs", but a lookup will work... to use VLOOKUP you will need to rearrange the lookup table/matrix, since VLOOKUP requires the searched value to be on the left most column of the lookup matrix.

Similarly to a VLOOKUP, you can use INDEX/MATCH as in the attachment.

Hope this helps

 

[Shazz]

Thanks for that, that worked great, is there any way the VLookup can be altered so that if a project code appears and is is not in the approvers list that it will automatically show as Sarah??

 

[PCosta87]

Thanks for that, that worked great

Don't mention it

is there any way the VLookup can be altered so that if a project code appears and is is not in the approvers list that it will automatically show as Sarah??

Sure, you can use IFERROR (see attached)