CREATE FORMULA IN EXCEL
 

I have items in a drop menu in D8 from a list in C29-C39. If the value of D8
= C29 then H14 (formula location) = D29

I have tried multiple versions of the below to no avail.
=IF(D8=C29,D29,IF(D8=C30,D30,IF(D8=C31,D31,IF(D8=C 32,D32,IF(D8=C33,D33,IF(D8=C34,D34,IF(D8=C35,D35,I F(D8=C36,D36,IF(D8=C37,D37,IF(D8=C38,D38,IF(D8=C39 ,IF(D39,D8=C40,""))))))

Thanks for any help!!
fyrefox

CREATE FORMULA IN EXCEL
 

Try this in H14:

=VLOOKUP(D8,C29:D39,2,0)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"fyrefox" wrote in message
...
I have items in a drop menu in D8 from a list in C29-C39. If the value of D8
= C29 then H14 (formula location) = D29

I have tried multiple versions of the below to no avail.
=IF(D8=C29,D29,IF(D8=C30,D30,IF(D8=C31,D31,IF(D8=C 32,D32,IF(D8=C33,D33,IF(D8=C34,D34,IF(D8=C35,D35,I F(D8=C36,D36,IF(D8=C37,D37,IF(D8=C38,D38,IF(D8=C39 ,IF(D39,D8=C40,""))))))

Thanks for any help!!
fyrefox

CREATE FORMULA IN EXCEL
 

In H14 enter =VLOOKUP(D8,$C$29:$D$39,2,FALSE)


Gord Dibben MS Excel MVP

On Sat, 13 Oct 2007 09:05:01 -0700, fyrefox
wrote:

I have items in a drop menu in D8 from a list in C29-C39. If the value of D8
= C29 then H14 (formula location) = D29

I have tried multiple versions of the below to no avail.
=IF(D8=C29,D29,IF(D8=C30,D30,IF(D8=C31,D31,IF(D8= C32,D32,IF(D8=C33,D33,IF(D8=C34,D34,IF(D8=C35,D35, IF(D8=C36,D36,IF(D8=C37,D37,IF(D8=C38,D38,IF(D8=C3 9,IF(D39,D8=C40,""))))))

Thanks for any help!!
fyrefox