Lookup table question

[anglais428]

Slightly trickier lookup problem.

I have a lookup table - for ease let's say that it is Table A below. What I would like to do is data validation based on this table. In another table, Looking at the cells in Column H (which correspond to the relevant Column A in the table below), If H2 equals "A1" then only "S1, S2, or S3" should be allowed in I2. If this is not the case then the row should be highlighted. So if H2 has "A1" inserted in it and "S3" is inserted in I2 - that is fine, however if "X2" is inserted in I2 then the row should be highlighted.

---

Table A

Column A	Column B
A1	S1
A1	S2
A1	S3

<tbody>
</tbody>

 

[delaneyjm]

Take a look at dependent lists.

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