if statement help

A

ack

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

Toppers

Guessing from the pattern ...

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

??
 
D

driller

guessing also from the pattern,

=IF(D19=P7:p14,V7:V14,"")

*array* entered with ctrl+shft+ent.

regards,
driller
 
Top