Iferror vlookup help!!!!!

[jnews]

I am desperately trying to write a formula that would lookup B5 & BC on a worksheet named "LookupPivots" to find cost between H:K in the 3rd position

So far I have this:
=IFERROR(VLOOKUP(B5,LookupPivots!$H:$K,3,0)+(VLOOKUP(C5,LookupPivots!$H:$K,3,0)),"0")

Which is returning 0 number. Since the second lookup does not have costs asscoiated, but the first look up does have cost. I know I have the value if error wrong, but I am not sure how to fix it.

I need the formula to only return 0 number IF both lookups do not have data. But if one does then to return that number or add both and return that number.

What in the world am I missing.

Please help!

 

[Andrew Poulsom]

Welcome to MrExcel.

Try:

=IFERROR(VLOOKUP(B5,LookupPivots!$H:$K,3,0),0)+IFERROR(VLOOKUP(C5,LookupPivots!$H:$K,3,0),0)

 

[jnews]

Are you kidding! I have been trying for days.... and in 2 min YOU are a life saver. Thank you sooooo much Andrew.