In the sample construct, A7:B7 contains:

Form Form#
C Form 11
D Form
E Form 13
F Form
G Form 15

[Forms: C Form, D Form, etc are listed in A8:A12. B8:B12 would be where the
inputs for the form numbers are made (I've assumed that only numeric inputs
for the Form# are to be recognised)]

For the sample numeric inputs in B8, B10 and B12,
A6 will return the text: List of C/E/G Form Received.

If the sample input in B8 is cleared (corresponding to "C Form"),
A6 will then return only: List of E/G Form Received.

And so on.

If the entire input range B8:B12 is cleared, A6 will appear blank.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---