I did have both workbooks open. However I agree, the VLOOKUP works fine, I was just looking for an easier way for our users to input a value, rather than looking up a code. i.e., rather than typing "PART123" in a cell to get the result from VLOOKUP, they would choose from a drop down list to populate the cell, to avoid the possibility of a typo.

I am still wondering why it did not work but, if in fact the sheet must be open, you are right, it's probably best to stick w/ VLOOKUP.

Thanks,
Allen