Which function wd I use to set up a ref to a list of possible name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Twishlist - 18 Apr 2007 04:42 GMT

This is chicken feed compared to the complex issues I've read on this site,
but your help would be greatly appreciated. My spreadsheet has 451 sites
listed in a column A. Listed against each site in column B is one of 10
possible contractors codes. I would like Column C to display a text name
associated with each potential contractor code. ie if a4 = 24, then show
Green Bros, if A4 = 32, then show Thomson & Co, etc etc

Reply to this Message

T. Valko - 18 Apr 2007 05:05 GMT

Create a 2 column table. The left column containing the contractor codes and
the right column containing the corresponding name.

Assume this table is in the range J1:K10

Then use this formula in your column C:

=VLOOKUP(B1,J$1:K$10,2,0)

Biff

> This is chicken feed compared to the complex issues I've read on this
> site,
[quoted text clipped - 3 lines]
> associated with each potential contractor code. ie if a4 = 24, then show
> Green Bros, if A4 = 32, then show Thomson & Co, etc etc

Reply to this Message

DonCam65 - 18 Apr 2007 06:04 GMT

Don't forget to sort column J in ascending order or it will not work

Signature

Don C

> Create a 2 column table. The left column containing the contractor codes and
> the right column containing the corresponding name.
[quoted text clipped - 14 lines]
> > associated with each potential contractor code. ie if a4 = 24, then show
> > Green Bros, if A4 = 32, then show Thomson & Co, etc etc

Reply to this Message

Peo Sjoblom - 18 Apr 2007 06:30 GMT

Only necessary if you don't want an exact match

Signature

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

> Don't forget to sort column J in ascending order or it will not work
>
[quoted text clipped - 21 lines]
>> > show
>> > Green Bros, if A4 = 32, then show Thomson & Co, etc etc

Reply to this Message

Twishlist - 18 Apr 2007 07:14 GMT

YES!! You are both fantastic...thanks so much.

> Don't forget to sort column J in ascending order or it will not work
>
[quoted text clipped - 16 lines]
> > > associated with each potential contractor code. ie if a4 = 24, then show
> > > Green Bros, if A4 = 32, then show Thomson & Co, etc etc

Reply to this Message