Dynamic Data Validation

Hi,

I am trying to use a VLOOKUP scenario for a data validation but I can't get it to work. I have looked at the Contextures information but cant decipher what I would like to do. In the contextures it shows all the lists as separate - can you not just amalgamate them?

I would like the data validation list to be limited based upon another cell looking at a table. Is this possible?

Please Login or Register  to view this content.

I am trying to return the values in column H:H where D1 matched column G.

TIH
Matthew

I've used a small macro to do this. See my attachement. that will clear things up. Change D1 and/orE1. Vallist is a 'named' range.

Good luck

Please Login or Register  to view this content.

This is triggerd by

Please Login or Register  to view this content.