Forum Discussion
Filtering based on two criteria and getting rid of #N/A values
First: I am desperately trying to sort through a database based on two columns/criteria (Tx and FLASK #) in order to return a list of all the associated values (RFU) that match those criteria. I've tried to apply the XLOOKUP function while using the "&" to reference both criteria/columns but to no avail.
Second: It would be really nice if I could also somehow remove any #N/A values from this list such that the output only includes a list of values that met both criteria
I've attached my measly attempt... Any help/guidance/ideas would be so so appreciated. Thanks in advance!
4 Replies
There is really only ONE filter criteria. And there are only 4 rows which comply with the filter.
Just filter the blue table.
But I also included a PQ- and a formula solution.
- Ah I see, then is there some way then I could also extract the "Tx" values associated with each of the "RFU" values as well?
