Data Validation

[Ghornet54]

Can someone please help me? I have a spreadsheet with 2 worksheets. In the first worksheet (named eval sheet) the second sheet is called list data. I want a data validation cell that when I choose a cell, the next cell will show a data validation of it's cell.

For instance.

D3 = N/A
D4 = N/a
E3 = AA
E4 = HARD

If someone in eval sheet in cell P7 chose N/A, P9 will only show N/A also. Likewise if someone in cell P7 chose AA, P9 will only show HARD and so on for 80 entries.

Please help!

Thanks for any help!

 

[Robert Mika]

Youe examples are D3,D4.... but you are refeing to P7.

When you have Data Validation in P7 in P9 enter
=IF(P7="N/A","N/A",IF(P7="AA","HARD",""))

This way P9 will show what's in P7.

 

[Ghornet54]

Thanks for the reply, but I have data from D3 all the way to BX4 and this would be a long formula. I was hoping for something simpler.

=IF(P7="N/A","N/A",IF(P7="AA","HARD",""))

I know if could say =IF (P7 ="D3", (D4), IF (P7 ="E3", (E4), IF (P7 ="F3", (F4), IF (P7 ="G3", (G4)), but I have 70 rows of information.

Thanks again.