Vlookup with Merge Cells using Index and Match Function

🔗 The Formula Explained: INDEX($C$2:$C$18, MATCH(E2&F2, $A$2:$A$18&$B$2:$B$18, 0))
📝 How It Works:
MATCH(E2&F2, $A$2:$A$18&$B$2:$B$18, 0): MATCH searches for the combination of values in cells E2 and F2 within the concatenated values of columns A and B (using the "&" symbol). It returns the position of the matched row.
INDEX($C$2:$C$18, ...): INDEX then uses the row position found by MATCH to extract the corresponding value from column C.