Trying to link data with validated cells

  • Thread starter Thread starter Kleamy
  • Start date Start date
K

Kleamy

I'm attempting to create a log file for shipments we receive. We have a
lot of vendors to keep track of, and they all have a vendor code. An
important portion of the log is ensuring the vendor code is included.


I'm having trouble with linking the vendor code with the vendor name.
For example, say I've validated the data in a cell, and there's a
drop-down list of companies to choose from. User 1 clicks on ABC, Inc.
I want 1234, ABC, Inc's vendor code, to pop up into the column next to
the column that contains ABC, Inc's name.

I've been told there is a way to do this, and it involves macros, but I
have never written a macro. Is there any way to do this? I found a
way to use the IF formula, but it only allows our first 7 vendors, and
we currently have 28 on the list, and that list will probably grow.

Any help is greatly appreciated!!

Thank you!!!!


+----------------------------------------------------------------+
| Attachment filename: receiving sheet.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=352382|
+----------------------------------------------------------------+
 
Kleamy

VLOOKUP can be used for this function.

Have your Vendors in one column and your Vendor codes in a column to the right
of this.

e.g.

Vendors in column A
Respective Codes in Column B

In C1 enter your Data Validation drop-down list, which is Vendors from Column
A.

In D1 enter =VLOOKUP(C1,A1:B10,2,FALSE)

Click on C1 and choose a Vendor from the drop-down list. The Vendor code will
appear in D1.

This is very basic idea. Ranges can be given names, can be on another sheet,
can be hidden etc.

Gord Dibben XL2002
 
Back
Top