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

Hi!

Try this:

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

Biff

"saladman74" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>

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:

--
saladman7
-----------------------------------------------------------------------
saladman74's Profile: http://www.excelforum.com/member.php...fo&userid=3174
View this thread: http://www.excelforum.com/showthread.php?threadid=51466