Linda- do you have a resource I can read on for making a sheet containing data (in this case, vintage abbreviations of states, not the current abbreviations), so that I can use it for lookups? Made-up (Not sure how referring to an outside workbook works): Cell C2 contains "AZ" In Cell D2, I would like to say: =vlookup(C2, Bookname:Sheetname:Range,2) [Or whatever is correct in this case] And "Ariz." Gets entered into D2. And in E2-- =vlookup(C2, Bookname:Sheetname:Range,3) [Or whatever is correct in this case] And "Arizona" gets entered into E2. If not Linda, anyone else please? I had been copying this info on the sheet itself to refer to it, but now that I am using it so much it would be nice to be able to put it somewhere permanent I can refer to as needed. Thanks. Robert ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************