If, VLookup, Index, or a combination of all of them?
"T. Valko" wrote:
What result do you want if no cells contain 1?
If there is no 1, for example, in a row, I'd like the returned value to be 0
(zero).
Try something like this:
="07."&IF(A2=1,1,"")&IF(B2=1,2,"")&IF(C2=1,3,"")&I F(D2=1,4,"")
--
Biff
Microsoft Excel MVP
This works perfect! And it was so simple!!
Thank you very much for your help. :)
|