How to use vlookup formula to look at two values before displaying a value

user_12006271 0
Viewed 28

I want my vlookup formula to first look for a date (column A), then look for a person's name (column B), then display the value of column C. I can get the formula to display the person's name (column B) but not sure where to go from here...

=VLOOKUP(L5, {DATA!A:A, DATA!B:B}, 2, 0)
gs-vlookup array-formulas google-sheets-formula google-sheets arrays
1 Answers

try like this:

=ARRAYFORMULA(VLOOKUP(E2&F2, {A:A&B:B, C:C}, 2, 0))

0

=ARRAYFORMULA(IFERROR(VLOOKUP(E2:E&F2:F, {A:A&B:B, C:C}, 2, 0)))

0

user_56326290
Related