Hello Excel Angels,


I have two Sheets;

Sheet A
Sheet B

in Sheet A, there's a lot of data arranged in Rows

1.PNG


In Sheet B, I need to fill in Data in Column C and D base in data from Sheet A.

2.PNG

Requirement:

In Sheet B column C, I need to return a value of "FXS" if there's an "FXS" value in Sheet A row 2 and "FXO" if the value found is "FXO".
In Sheet B column D, I need to return a value of "Registered" if there's a value "Registered" found in Sheet A row 2. and "Unregistered" or "FXO" if these are found. (none of these 3 exists in same row)

Please help and thank you in advance