Column of Text is same as Column of Values
 

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.


--
saladman74
------------------------------------------------------------------------
saladman74's Profile: http://www.excelforum.com/member.php...o&userid=31747
View this thread: http://www.excelforum.com/showthread...hreadid=514661

Column of Text is same as Column of Values
 

Hi!

Try this:

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

Biff

"saladman74" wrote
in message ...

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.


--
saladman74
------------------------------------------------------------------------
saladman74's Profile:
http://www.excelforum.com/member.php...o&userid=31747
View this thread: http://www.excelforum.com/showthread...hreadid=514661

Column of Text is same as Column of Values
 

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


--
saladman74
------------------------------------------------------------------------
saladman74's Profile: http://www.excelforum.com/member.php...o&userid=31747
View this thread: http://www.excelforum.com/showthread...hreadid=514661