vlookup

  • Thread starter Thread starter confused
  • Start date Start date
C

confused

I can not seem to figure out how to look up
information... I am trying to insert a code into D3 and
the table containging the code is in L2:M12. I am using
10 letters to represent numbers 1,2..8,9,0
those letters are to be typed in the "D" column, no more
than 6 consecutive letters (they will not represent a
value greater than $9,999.99

I can not get the vlookup to work for me. I plan on using
it for several lines and I have used the tutorials and
the office assistant...I am still confused!

Please help....
 
Hi
first: please don't multipost this question to nearly all
Excel forums :-) most regulars will read all therse forums
and maybe get annoyed by reading this again and again :-)

For your question: I'm still not sure what you have in
your cells (maybe you can post some example rows of your
column L,M and cell D1 -> plain text no attachment please).

If you enter only ONE single value in cell D1 use
=VLOOKUP(D1,L2:M12,2,0)

But I assume from your question that you will enter
several values in ONE single cell (cell D1). Is this
correct?.
 
Back
Top