I have no neat solution for the following (I do IF statements followed by lots of hand editing). Please lift me out of the dark ages (MS access is a great solution, but I need a quick Excel solution).
I have a list like
A
B
D
F
G
with lots of lovely useful data associated
Then I discover a...