Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ARRAYFORMULA(VLOOKUP(A1&B1, {Sheet1!A1:A4&Sheet1!B1:B4,Sheet1!C1}, 3))
- QUERY({Sheet1!A1:B4,A1:B5}, "Select C where ")
- =MATCH(A1&B1,{Sheet1!A1:A&Sheet1!B1:B})
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement