Aircraft nationality could be extracted fromthe reg by way of a look-up table on a seperate sheet for the formula to reference - this is easy. But where would you look-up the cross reference between aircraft reg and type? Is this available in a form that can be "consulted" automatically? If not then you're probably going to struggle.
PDR