Column of Text is same as Column of Values

[saladman74]

I am such a n00b.

Cell B25 has a validated list of items (text items referenced to
columns J1 through J18). I want each of the J# cells to correspond to
eighteen numbers in columns V1 through V18. What I want to do is have
the list from B25 automatically pull up the value of the V# column when
an item is selected and fill in B26 (no math, just giving the cell
value). The J#s are text items, and the V#s are numerical. How can I do
this?

J1 (Item 1) = V1 (0)
J2 (Item 2) = V2 (5)
J3 (Item 3) = V3 (8)
etc. etc.

B25 (Item from J) *This is a drop down list.
B26 (Number from V) *I want this to automatically pop up when B25 is
selected.

 

[Biff]

Hi!

Try this:

=INDEX(V1:V18,MATCH(B25,J1:J18,0))

Biff

 

[saladman74]

Oh wow, thanks! That works PERFECTLY. I thought I could get J to equal
somehow, but it kept giving me errors with everything I tried. Again
thanks: