VLOOKUP QUESTIONS

Pauljj

Well-known Member
Joined
Mar 28, 2004
Messages
2,013
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
 

Some videos you may like

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.

ken2step

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

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690

ADVERTISEMENT

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
Joined
Mar 28, 2004
Messages
2,013
My look up source is going to be on a different worksheet, will this make any difference ?
 

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632

ADVERTISEMENT

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
Joined
Mar 28, 2004
Messages
2,013
Sorry, what I meant to say was that my table would be in a different workbook not a different worksheet
 

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
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
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,322
Members
412,716
Latest member
thviid
Top