Hello

I have 6 columns of data say columns 1 to 6 and depending on the value of another cell (say A1) I would like the data from one of these 6 columns to appear in say column 7.

So:
If the value I enter in A1 is say “Y1” I would like the date from column 1 to appear in Column 7
If the value I enter in A1 is say “Y2” I would like the date from column 2 to appear in Column 7
If the value I enter in A1 is say “Y3” I would like the date from column 3 to appear in Column 7
Etc.

This will then allow me to produce a drop-down box based on Column 7 with a pick list that corresponds to the status of the cell containing the manual input of Y1 to Y6.

Many thanks