Lookup in one table and display two values in another

Hello,

I am officially driving myself insane as I know this shouldn't be as complicated as I am making it! Any pointers would be very much appreciated!

In Table A I have several columns including supplier (Column B), invoice number (Column C), amount (Column D) and Paid (Yes or No) (Column E).

In Table B I have the suppliers listed in separate columns. I am attempting to look up a supplier in table A and if the invoice number in column C is not paid (a No in column E) the invoice number and amount is to be displayed in columns B and C of Table B.

Please can someone point me in the right direction before my old brain finally explodes!?

With many thanks.
Paul

Sample.xlsx

Thank you for the suggestions and I've uploaded a sample now along with the desired outputs on.

Any help would be really appreciated.

Kind regards.
Paul

Originally Posted by Ace_XL

In b6..

Please Login or Register  to view this content.

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