use the VLOOKUP function in the Supplier Name cell. If you are going to type
the number in cell A1, put this formula in B1

=VLOOKUP(A1, range for table on other sheet, 2, false)

The false at the end indicates you want Excel to generate a formula error if
the number doesn't match anything in the table



"Christopher in Bellefontaine" wrote:

Ladies and Gentlemen:

I am trying to do something that seems like it should be very simple, but I
cannot, for the life of me, figure out how to get it to work.

I want to create a basic table in Excel, Column A being Supplier Number and
Column B being the Supplier Name.

On a seperate worksheet, I need to enter BOTH items of information in a
simple form I created. I am trying to set it up so that once I enter the
Supplier Number in one box, then the Supplier Name will automatically be
entered in the appropriate box based on the simple table of Supplier Number
and Supplier Name.

I have tried many, many sources to try to find the answer to this problem,
but have had no luck at all yet. Can someone please assist me with this
problem, or am I thinking it should be simpler than it actually is?

Oh, one more note, I don't want to use Access to design this form for work
reasons. I need to have this work in Excel, so advice on how to do this
would be greatly appreciated.

Thanks Very Much,

Christopher