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.