Velvet Dan
New Member
- Joined
- Oct 28, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hello,
I am trying to look up and return all invoice #'s that were paid in the year 2021. The invoice #'s and year paid are two separate columns. I would like to return all the applicable invoice #'s in column A in another sheet. I have attempted the problem myself using the INDEX function but it only returns the first matching value. Below is the current formula I'm using. I'm using tables so you will notice I have table references instead of ranges.
Thank you in advance!
Sincerely,
Dan
I am trying to look up and return all invoice #'s that were paid in the year 2021. The invoice #'s and year paid are two separate columns. I would like to return all the applicable invoice #'s in column A in another sheet. I have attempted the problem myself using the INDEX function but it only returns the first matching value. Below is the current formula I'm using. I'm using tables so you will notice I have table references instead of ranges.
Excel Formula:
=INDEX(InvoiceTable[Invoice '#],MATCH(0,IF(InvoiceTable[Year Paid] = 2021, COUNTIF(InvoiceTable[@[Year Paid]],InvoiceTable[Invoice '#]), ""),0))Thank you in advance!
Sincerely,
Dan
