... or if you can do it Excel but I wanted to find out. What I want to do is have a list in one spreadsheet that has a vendor ID # and then the vendor name. In another spreadsheet I want to be entering data and when I type the vendor ID into one cell in a column I want the vendor name to automatically fill in into the cell in the adjacent column in the same row. I know Access has a function like this but I'm trying to do it in Excel but I am sure what to call it so I can look it up in Excel help.