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?
Bookmarks