Pulling in data from a register

Hi there,

I am looking to try an use a formula, to pull information from a register onto a "frequency" table before it has been populated with the data, to allow users to complete the register and not have to follow up with the "frequency table"

I have attached a sample version that shows column B and C as the register that lists the register number and then an initial. The second table i would like a formula to review the column B, and search for a new initial that doesn't already exist in column E and add it in. The idea behind it is so i can leave the second table to kind of auto populate whilst others populate the register.

Any suggestions would be greatly appreciated!

This has worked! thanks very much for your help!