CODEWITHSUNDEEP
excelvlookup
SouravD
SouravD

Reputation: 127

Excel Lookup on multiple conditions

I have two tables

enter image description here

And

enter image description here

The table structure remaining the same, how do I write a lookup statement on excel to get the output in Table 1

Upvotes: 0

Views: 117

Answers (1)

pnuts
pnuts

Reputation: 59432

No formula as you do not show cell references, but the conventional solution is to add a column concatenating Date and Source for the lower table and then apply a lookup function with a search term that combines Date and (separately) each of the other two labels in Table 1.

Upvotes: 1

Related Questions