Multiple Arrays constructing new array

[griffter]

Hi All, hope someone can help me again!!

I need to create an array from several fields and although I know what I want to do I am struggling a bit with syntax etc.

I need to loop through Field A if Null then pass to my new array, if xyz is in field B then find position and return value for this position from Field C to my new array.

FieldA FieldB FieldC FieldD
Null ABC TextA Null
Null DEF TextB Null
XYZ GHI TextC TextE
NUll JKL TextD Null
Null XYZ TextE Null

Any help with constructing this formula would be appreciated.