The "Type" fields contain various categories in a 3 number/figure format.

I'm looking for the first Type field where "RFS" does NOT appear.

When it finds this first occurance, I want to create a column that returns the corresponding detail.

So I want it to look at existing columns and return the result in a new column...

I don't know if that explains it better. Let me know what else you would want to see.

Regards

Peter