I'm not really sure what this function is called...

[Aries86]

... 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.

[bebo021999]

You can search for VLOOKUP function
Cheer,

[dilipandey]

Hi Aries86,

Welcome to the forum.

This facility in Excel are known as Lookup functions i.e, Vlookup, Hlookup, Lookup, Index /Offset, Match etc....

You can simply use Vlookup in your case where-in you need to enter vlookup formula on column 2 of another spreadsheet. After this when you'll enter vendor Id in column 1 of another spreadsheet, you will get vendor name in column 2.

In case of any issues, post your sample file. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

[Paul]

Hi Aries, welcome to the forum.

Please take a moment to read the forum rules - there is a link in my signature - and then amend your thread title to something descriptive of your problem (not the anticipated solution/function). Your issue isn't that you don't know the name of a specific function (we can help you select the best one), it's that you need to type a value in one cell, look it up on another sheet and return a corresponding value.

Thanks.