# VLOOKUP QUESTIONS

#### Pauljj

##### Well-known Member
In cell D5 I need a list of different operators to appear.....the list appears on another page, for a start, how can I do VLOOKUP for this ? The second question maybe a bit harder, is, every operator has a 1 or 2 letter code, so say for example I from the cell D5 select ATI (The code for ATI is Z) if ATI is selected I want Z to appear in Cell E7...how can i do that please ?

Thanks

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

##### MrExcel MVP
1) use data validation.

2) use a vlookup.

#### Pauljj

##### Well-known Member
That was the part i did know....it was the rest I dont

#### ken2step

##### Well-known Member
Book2
ABCDE
1ATIZ
2FBIY
3UITX
4Validation for cell D5 use List, Source would be =a1:a3
5ATI
6
7Z
Sheet1

#### lenze

##### Legend

Using Ken2Step's example. I suggest you name the cells (or the equivalent in your worksheet) A1:A3(say ValRange)
Now name cells A1:B3 (say myTable)

Now for A5, the validation source would be ValRange and the VLookup would be

=VLOOKUP(B5,myTable,2,0)

HTH

lenze

#### Pauljj

##### Well-known Member
My look up source is going to be on a different worksheet, will this make any difference ?

#### ken2step

##### Well-known Member

Then you'll need to name the range as Lenze has said above. Then you can use that Named Range as your list as the source in your validation.

#### Pauljj

##### Well-known Member
Sorry, what I meant to say was that my table would be in a different workbook not a different worksheet

#### ken2step

##### Well-known Member
You can still do the same thing as above, just add the workbook name to your range name such as:

=[WorkbookNameHere]SheetName!\$A\$1:\$A\$3

Replies
4
Views
45
Replies
1
Views
254
Replies
1
Views
97
Replies
26
Views
188
Replies
5
Views
202