CODEWITHSUNDEEP
arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
Austin Farmer
Austin Farmer

Reputation: 125

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

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)

Upvotes: 2

Views: 33

Answers (1)

player0
player0

Reputation: 1

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

Upvotes: 1

Related Questions