Your issue can be solved by using
How it works:
- I'm assuming that you have Source data in Range
- Enter Target data in Range
Enter this Array (CSE) Formula in cell
finish with Ctrl+Shift+Enter and fill down.
Let me explain mechanism behind the Formula.
MATCH formula configured with
MATCH set to look through a one column range and provide a match based on given criteria, without concatenate values in a helper column, or in the Formula itself.
But the shown Formula works around this limitation by using boolean logic to create an Array of
0 to represent rows matching to
2 criteria, then using
MATCH to match the first
The temporary Array of
0s is generated with this combination.
Adjust cell references in the Formula as needed.