Pull data from one sheet based on data in another sheet

On sheet 'Client Ledger' I am inputting items bought for and charged to a client.
On 'InvoiceReceipt' I am creating either an invoice or a receipt for the client. If F1 says 'Client Statement' I would like it to pull all unpaid items from sheet 'Client Ledger' and put them onto the statement. If F1 says 'Receipt' then I would like it to pull all unpaid items from sheet 'Client Ledger' and put them onto the statement.

I would prefer for this to not be VBA -- but if it has to be I will definitely work with it. Any help would be greatly appreciated!!

It is not letting me add an attachment. I will try again in a little bit -- but if anyone has any ideas - they would be greatly appreciated!

https://www.excelforum.com/attachmen...1&d=1560041987

I am not seeing anything.

It came up.
When I change it to Receipt, nothing changes.

Is there a way to do this so that it automatically pulls the information when I change it to Receipt or is that a VBA thing? If VBA, can you help me set that up?

I keep changing F4 from Client Statement to Receipt and nothing is changing.

=IFERROR(CHOOSE(MATCH($F$4,{"CLIENT","RECEIPT"},0),INDEX('Client Ledger'!$A$2:$A$5,SMALL(IF('Client Ledger'!$D$2:$D$5="no",ROW('Client Ledger'!$D$2:$D$5)-ROW('Client Ledger'!$D$2)+1),ROWS($A$13:A13))),INDEX('Client Ledger'!$A$2:$A$5,SMALL(IF('Client Ledger'!$D$2:$D$5="Yes",ROW('Client Ledger'!$D$2:$D$5)-ROW('Client Ledger'!$D$2)+1),ROWS($A$13:A13)))),"")

Except it has the array brackets.

It isn't working for me at all.

Is calculation set to automatic?

If you have been using any VBA procedure that temporarily disables calculation while it runs, an error in the code could cause it to be left disabled afterwards.

Change F4, then press the f9 key or save the file. Does anything change then? (Try this twice just to be sure that you haven't changed it back to the original content).

If this has happened, then to re-enable automatic calculation, press f11, then Ctrl g and enter the code below into the 'Immediate' window (the white box at the bottom of the vba editor)

Please Login or Register  to view this content.

and press enter.
*** Note that the cursor must be on the same line as the code before pressing enter, otherwise it will not work ***

You will also need to investigate and fix the cause of the error in your code which has caused this to prevent the problem from happening every time you run it.