VLOOKUP QUESTIONS

[Pauljj]

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

 

[PaddyD]

1) use data validation.

2) use a vlookup.

 

[Pauljj]

That was the part i did know....it was the rest I dont

 

[ken2step]

Book2
	A	B	C	D	E
1	ATI	Z
2	FBI	Y
3	UIT	X
4	Validation for cell D5 use List, Source would be =a1:a3
5				ATI
6
7					Z
Sheet1

 

[lenze]

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]

My look up source is going to be on a different worksheet, will this make any difference ?

 

[ken2step]

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]

Sorry, what I meant to say was that my table would be in a different workbook not a different worksheet

 

[ken2step]

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