Lookup in one table and display two values in another

Originally Posted by Ace_XL

In b6..

=IF(INDEX(TableA!$D:$D,MATCH(A3,TableA!$B:$B,0))="-",INDEX(TableA!$C:$C,MATCH(A3,TableA!$B:$B,0)))

copy down and across

Apologies for a stupid question but this doesn't carry across the invoice number but just the amount? Am I missing something?

I want to lookup the values in Table A and display the invoice number and amount in the correct supplier columns in table B. Is there a way I can achieve this?

Thanks again for the help which is appreciated!!

Best wishes.
Paul

Originally Posted by Fotis1991

See if this take care your needs. I done only for the first sample. Same way for the others.

Excellent - many thanks for the help!!

Paul