guessing also from the pattern,

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

*array* entered with ctrl+shft+ent.

regards,
driller
--
*****
birds of the same feather flock together..



"ack" wrote:

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!!