Excel Multiple Search

Question

Excel Multiple Search

I have two tables

enter image description here

AND

enter image description here

The structure of the table remains the same, how to write a search statement for excel to get the result in table 1

0

excel vlookup

SouravD 21 Aug At 10:11

source to share

1 answer

pnuts · Accepted Answer · 2014-08-21T10:49:08+0000

None of formula, as you do not indicate a reference to a cell, but the usual solution is to add a column combining Date

and Source

for the bottom table and then applies the search function with the search term that combines Date

and (separately) each of the other two markers in Table 1.

Excel Multiple Search

More articles: