Using Lookup - Need a manual option if no match found

[Anonymous]

Morning All

I have a working lookup function as per below.

Below displays the value ok where I get a match ie the lookup is True/works AS EXPECTED

If I don’t get a match I want an alternative result which can be 0

The lookup column that Im displaying is a % column so XERO works fine

I’ve tried various options for an alternative result and its not working.

Any help appreciated.

LOOKUP_LEAN_IX_PERCENTAGE = LOOKUPVALUE(
LEAN_IX[%_Complete]
,LEAN_IX[APPLICATIONID]
,POAP[Lean IX ID_DOD]
)

Jimmy

[Anonymous]

@ryan_mayu 

I feel embarrased, why did I not think of this?

Indeed it works perfectly well.

Thanks for the Tip.

Jimmy

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

what about add 0 as the last parameter

LOOKUP_LEAN_IX_PERCENTAGE = LOOKUPVALUE(
LEAN_IX[%_Complete]
,LEAN_IX[APPLICATIONID]
,POAP[Lean IX ID_DOD]
,0)