I have three columns (A,B,C) table:
red pencil 4
green pen 2
blue pencil 2
green pen 1
white pen 3
cyan pen 4
blue pen 1
I want to have a 4th column, which will get value from 3rd column C, if column A and column B are true for my search. For example: =IFS(A:A,”red”,B:B,”pencil”, D:D=C:C) should yield 4. I just made up this function. But I’m sure there must be some elegant way of achieving it.
Thanks for the help in advance.
Bookmarks