It seems like an elegant solution but I can't get it to work.

I get an "Invalied cell reference error".

Is there any chance you can explain what each part of the formula means?

I can get this to work for a single field but autofill doesn't work...

Thanks for your help.