In the second sheet:

Assume you put the supplier number in C1:

=VLOOKUP(C1,Sheet1!A:B,2, False)


In article ,
"Christopher in Bellefontaine"
. com wrote:

Help, please! I have been literally tearing my hair out trying to figure out
how to get this to work for over 6 months now, and I am still coming up empty.

Here is what I have.

Column A Column B
Supplier # Supplier Name
xxxxxxxx Nishikawa
xxxxxxxx Johnson Controls
xxxxxxxx Furukawa
xxxxxxxx Honda Lock
xxxxxxxx Takata Petri

Etc., etc. (there are approximately 1000 different supplier numbers with
corresponding supplier names).

This is on one worksheet. In the same book, I have another worksheet that
has a form that requires data to be entered into it on a daily basis. I have
cells that require the Supplier Number and Supplier Name be entered. I wish
to set this sheet up so that as soon as I enter the Supplier Number in one
cell, the corresponding Supplier Name will be entered in the appropriate
cell. I have this form copied many times on one sheet, as each set of cells
corresponds to a typed Incident Number, so I need this formula to work many
times on the same sheet, each time I enter the Supplier Number the
corresponding Supplier Name is entered in the appropriate cell.

This seems to me like something that should be fairly simple to do, but I
CANNOT FIGURE OUT HOW TO DO IT! Any assistance from you guys and gals would
be GREATLY appreciated!