Have a look in the help index for
OR

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Drew" wrote in message
...
Hello everyone.

I am wanting to use the following IF formula and it only covers 8 out of
12 cells in a row that I need to extract data from.

=IF(F4=F10,E4,IF(G4=F10,E4,IF(H4=F10,E4,IF(I4=F10, E4,IF(J4=F10,E4,IF(K4=F10,E4,IF(L4=F10,E4,IF(M4=F1 0,E4,"-"))))))))

There has to be a better way. Help please.

Thank you. Drew.