Can anyone teach me how I can return a value from a column if multiple criteria are met where if:
- a cell in a column of another sheet contains a word in a cell (referenced)
- the same row in another column contains
- the same row in another column contains a text in a cell (referenced)
I tried doing this:
but this doesn't return a value. So, I tried using
MATCH using an array formula like this:
but somehow this returns an error:
Did not find value "1" in
Am I doing something wrong with my
MATCH? I'm not sure what's going on here.
And also would this be heavy if I were to do this to 10k cells? Would a script/using
QUERY be better in returning these fields?