Dear Rebecca,
Translating Old Greek? Pretty advanced for a six-year-old, I must say! :) :)
The formula I wrote won't do it. Chuck's filtering method will, but you
would have filter each sheet for the same combination of B and D, paste the
translation into each one, and then re-filter each sheet for the next
combination. I'm going to think about this and get back to you some time
today.
Regards,
Ian.