Thanks for that.



I tried it but it doesn't quite do what I need. Ideally in the third sheet the formula / function would automatically place vertically the applicable values / data from sheet 1 and sheet 2 without every cell in sheet 3 only corresponding with an exact cell in one of the other two. It would be handy if I could put the retrieved values into alphabetical order as well.