Google Sheets Match/Index Query

user_16701090 0
Viewed 73
vlookup array-formulas google-sheets indexing arrays
1 Answers

use:

=INDEX(IFNA(VLOOKUP(F2:F, {Q2:Q, P2:P}, 2, 0)))

enter image description here

user_56326290
Related