Hello and thanks in advance for all the help.
The lookup formula below works like it should with one small problem. If the part in red is blank or empty it returns -0-, which I don't want. I need it to return nothing at all. Perhaps this is not the right formula to use. Not sure. My formula will always have 3 criteria. How can I modify this to achieve the results I need?
=LOOKUP(3,1/('JE Mapping'!$A$2:$A$150=Detail!$C2)/('JE Mapping'!$B$2:$B$150=Detail!$E2)/('JE Mapping'!$C$2:$C$150=Detail!$F2),('JE Mapping'!$F$2:$F$150))
Thanks again!
The lookup formula below works like it should with one small problem. If the part in red is blank or empty it returns -0-, which I don't want. I need it to return nothing at all. Perhaps this is not the right formula to use. Not sure. My formula will always have 3 criteria. How can I modify this to achieve the results I need?
=LOOKUP(3,1/('JE Mapping'!$A$2:$A$150=Detail!$C2)/('JE Mapping'!$B$2:$B$150=Detail!$E2)/('JE Mapping'!$C$2:$C$150=Detail!$F2),('JE Mapping'!$F$2:$F$150))
Thanks again!