Extract values from a database based on a specific criteria

Good morning to you all,

I am trying to find a way to extract specific information from a database according to a specific criteria.
Using VLOOKUP or IF functions is not enough, since just part of the list includes the criteria to filter on.
I can't find a way to not have the lines FALSE or #N/A, except by ordering the column where my text for the criteria used in Excel functions is.

In the excel attached, tab "invoice list" is the database.
From this database, I extract various information based on the criteria in column Q.
For example, tab "b2b" needs to display all information for invoices where "b2b" is mentioned in column Q of tab "invoice list".
I know how to retrieve data when the invoice number is displayed in B2B tab, but I can't find a way to exclude lines which are not compliant with the criteria in tab B2B.

Can you help please?

Hi,

Can you not add an IFERROR function in the beginning?

Try the following,

In A5 ('b2b' tab):

=IFERROR(VLOOKUP(B5,'INVOICE LIST'!C:N,12,FALSE),"")

Hello cbatrody,

Thanks for the quick answer.
my question is especially on how to fill in column B in tab B2B.
I'd like to only get invoice numberin column B of tab B2B for invoices where column Q in tab INVOICE LIST is equal to "b2b".
In my template file, column B is manually populated. I would like the column to be automatically updated based on the values from the database INVOICE LIST.

Hi,

Try the following array formula in B5 ('b2b' tab):

=IFERROR(INDEX('INVOICE LIST'!$C$2:$C$13,SMALL(IF('INVOICE LIST'!$Q$2:$Q$13="b2b",ROW('INVOICE LIST'!$C$2:$C$13)-MIN(ROW('INVOICE LIST'!$C$2:$C$13))+1),ROWS($A$1:A1))),"")

to be confirmed by pressing CTRL+SHIFT+ENTER

Yes! This is exactly what I was trying to do!
Thanks cbatrody!!

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.