LOOKUPVALUE returning some blank values, how do I use MAXX?

[ergocorp]

Hi all,

I have used LOOKUPVALUE to try and bring a column in from another table, I've tried all variations on trim, clean even manually editing the source data line by line to check there are matches, and I keep getting this:

I have exhausted matching columns (I have 5 pairs in the LOOKUP). A search on here suggests I use MAXX(FILTER(...)...)

However I have no idea how I'd implement that into this lookup:

PO Qty = LOOKUPVALUE('1. Manhattan Logs'[Q],'1. Manhattan Logs'[P],'2. Uplift Log'[P],'1. Manhattan Logs'[Item Description],'2. Uplift Log'[Description],'1. Manhattan Logs'[Depot],'2. Uplift Log'[Depot],'1. Manhattan Logs'[GR Date].[Date],'2. Uplift Log'[Date (dd/mm/yyyy)].[Date],'1. Manhattan Logs'[Article],'2. Uplift Log'[Article])

Anyone can tell me?

[vicky_]

LOOKUPVALUE() will return blanks if there's more than 1 match for your row. In that case, you can provide an alternative result as the last parameter. So i think something like:
LOOKUPVALUE(___your existing function___, 

    MAXX(FILTER(TableName, [Column] = 'Table'[LookupColumn] && [Column2] = 'Table'[LookupColumn2]...etc

))

[ergocorp]

Thanks Vicky_ however, your solution doesn't have a second argument for the MAXX function. I'm so lost this is actually driviing me loopy haha