kingcole wrote:
Thanks for the post but that doesn't seem to work because the table I
have with the value I want to select is on another worksheet. Any
other ideas?
What????
Neither INDEX nor MATCH require the table to be on the same worksheet. So if
it doesn't work it is for some reason other than that "the table I have with
the value I want to select is on another worksheet"

I just tried it and it works fine. Suppose you post what you are doing and
we look at what's wrong with it?