Issue with multiple criteria in Lookup formula

easybpw

Active Member
Joined
Sep 30, 2003
Messages
406
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
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!
 

Some videos you may like

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
Joined
Jun 12, 2014
Messages
50,903
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,808
Messages
5,574,434
Members
412,592
Latest member
moonsugar
Top