# Issue with multiple criteria in Lookup formula

#### easybpw

##### Active Member
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!

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### Fluff

##### MrExcel MVP, Moderator
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.

Replies
2
Views
73
Replies
5
Views
124
Replies
3
Views
51
Replies
6
Views
28
Replies
7
Views
203