if statement help

[Guest]

I have a formula that won't let me enter in any more if statements. Can you
help
This is what I have:

=IF(D19=P7,V7,IF(D19=P8,V8,IF(D19=P9,V9,IF(D19=P10,V10,""))))

I have 8 of these if statements in the one cell and it won't let me put in
any more. Is there a different formula that I can use or modify this one?

Thanks!!

 

[T. Valko]

Try it like this:

=IF(COUNTIF(P714,D19),INDEX(V7:V14,MATCH(D19,P714,0)),"")

Biff

 

[Guest]

Guessing from the pattern ...

=IF(ISNA(VLOOKUP(D19,P7:V18,7,0)),"", VLOOKUP(D19,P7:V18,7,0))

??

 

[Guest]

guessing also from the pattern,

=IF(D19=P714,V7:V14,"")

*array* entered with ctrl+shft+ent.

regards,
driller

 

[T. Valko]

Not sure what you're thinking but that won't work.

Biff