Issue with multiple criteria in Lookup formula

[easybpw]

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!

 

[Fluff]

Can you post some sample data using the XL2BB add-in
Also what version of Excel are you using?
Please update your account details to show this, as it affects which functions you can use.