Vlookp up - sort of

  • Thread starter Thread starter Ntisch
  • Start date Start date
N

Ntisch

Hi,

I'm trying to combine a list of numbers, text and vlookup.

In column A I have a list of numbers in descending order (1, 2,
etc).

In column B I have a list of text (syd, melb, adel etc).

In column C I have a list numbers that relate to the cells in column B
For example if syd is typed into column B2, column C2 is equal to th
value 100

What I would like to do is be able to type text (syd, melb, adel etc
into a cell, in column D, and have the value that corresponds to tha
cell from column C be generated automatically underneath. So, from th
example above I would type the text Syd in cell D1, and the figure 10
would appear in cell D2.

Any ideas on how I could achieve this?

Help appreciated, Ni
 
Back
Top