Formula Question

HZAR

Hi @Paul Newcome

I am not asks for the color coding

Below is my previous question that still not sure where is the error. Thanks

As per the flow that is required I have amend the formula as below which is currently giving me the error

=IF(OR([Item Status]@row ="Life Time Buy (LTB)", [Item Status]@row ="Bridge Buy (BB)"),"adrienanurashyiqin.bintizainol@motorolasolutions.com", IF([GSP Status]@row = "Cancel", "", IFERROR(INDEX({Site Ivt Lead}, MATCH([EMS Site]@row, {Site1}, 0)), "")))

The flow will be

Item Status=LTB or BB , EMS Site-Any-Lead name will be adreina

Items Status is not under LTB or BB, It will Vlook Lead name based on the EMS site

If GSP status =Cancel, Lead name will be blank

HZAR

Hi @Paul Newcome

I managed to fix the issue…thanks

Paul Newcome

I know you didn't ask for color coding, but the color coding in the sheet helps provide additional indicators of other things that could be wrong that are not necessarily apparent when you just copy/paste a formula such as a potential column name being misspelled.

HZAR

Hi @Paul Newcome

Ok noted on the message and really big thanks for the guidance that you have provided ;)