I have a table where I want to pull the value in Column B on the row in which the data I am looking up is located.
A - B - C - D - E
xyz - x - x - x - x
def - x - y - x - x
ghi - x - x - x - x
In this example i want to create a formula that will result in 'def' because of where the y (in this case column 'c') knowing that the y could show up anywhere in the table B - E
My original thought was =index(A:A,match('y',B:E,0)) but realized i can not do the array portion of the match function across multiple columns. Is there another way of doing this?
Thanks.
Josh
Bookmarks