I have a spreadsheet with NAME in col A and dates in Cols B-N. Under column
A, I have a list of the names. The names have been asked to mark which date
they would like by putting an X in the appropriate col next to their name.
This has given me a grid showing the names and their choice of date.
However, I now want to mark their choices in another single column, which
will show the actual date they have chosen. Rather than type each one out,
I'd like to use a formula that looks along the row next to the name and
returns the date from the column where the X lies. But how to do? Pls help,
thanks, Annie.