Return a specific column of data depending on the content of a cell

[Herr Rommel]

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

[Pete_UK]

Note that A1 is in column 1 (so your other columns might be 2 - 7 or B to G, with results in column 8, or H).

Why not just enter 1, 2, 3 instead of Y1, Y2, Y3 ?

If I were you I'd check out Debra Dalgleish's site on dependent data validation - here's a link to it:

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete

[Herr Rommel]

Pete_UK, thanks for the link. Lots of useful information so managed to sort my problem out from that. Many thanks.