Matching cells to give a result for invoices paid or not paid

[George1]

Hi there,
I have two lists on one spreadsheet with the invoice number being common to both lists.
The list on the left is from a supplier and the one on the right is my list.
The list is about 2,000 lines and what the supplier wants to find out is if I have received their invoice and is it paid or not.

I have carried out a match between both lists and I have clarified what invoices I've received. What I want to know is - is there a formula that will tell me of what invoices I've received, what is paid and what is outstanding when compared to the suppliers list.

https://drive.google.com/file/d/12pqQ-rt186SPc5Kyajm47xS3YadWf3Y0/view?usp=sharing

Any help would be appreciated.

Regards
George

 

[kweaver]

Are you trying to fill in the E column with the amount paid as indicated in M, but if the invoice has NOT been paid (as indicated in M), then E is blank? If so, try:

=IF(VLOOKUP(B2,$K$2:$M$8,3,FALSE)="Yes",VLOOKUP(B2,$K$2:$M$8,2,FALSE),"")

In E2, filled down.