i need to retrieve a number from a spreadsheet but only if two values are found to match. i've attached an example that shows my dilemma. i'm trying to think of a way but i can't figure it out. what i've come up with in my head is something like a If(And(Index(Match)), Index(Match)) function.
in the example file: if D matches a value in A AND E matches B, then retrieve the value in F.
any help would be appreciated!
Bookmarks