Match two lists of data, if set A is >25% of set B output difference

[eldoradotower]

I have dynamic two lists of data that load from and ODBC connection. One contains outstanding balances for customers. The other contains outstanding balances aged 72 days or greater. I need to find matches in the two lists. If a match exist I need to determine if the balance aged 72 days or greater is more than or equal to 25% of the total balance. If this is the case I need to know the difference of the two balances.

Here is an example.

Company Balance over 72 days Company Total Balance output
Target 1000 Dell 4333 0
Walmart 5000 Apple 5634 0
Costco 2000 Target 5000 0
IBM 6000 0
Walmart 4000 1000
Costco 500 1500

Thanks!

[Alexander40]

Try

=IF(NOT(ISNA(VLOOKUP(A2,C2:C71,FALSE))),IF(VLOOKUP(A2,C2:D7,2,FALSE)>=0.25*B2,VLOOKUP(A2,C2:C7,2,FALSE)-B2,0),0)

[eldoradotower]

Thanks but it says

#NAME?

Does it work for anyone else?

[martindwilson]

Please Login or Register  to view this content.

in cell e2 and dragged down
edited for typo and length!