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