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
Thanks