Try it like this:

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

Biff

"ack" wrote in message
...
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!!