Frank is right. VLOOKUP works

When we did this in 97, there was an issue. I don't remember precisely what it was, but it had to do with the way the drop-down validation fires events

We did it in 2000 successfully