Greetings people.
I need some help from you experts out here.
I'm trying to write a formula to search for a value in a matrix and return a value from a separate column in the rows where the values are found.
Attaching a file to help illustrate what I want.
I want to search for the values from the green fields in the yellow area, returning the value from purple field of the rows where the values are found into the blue area.
so for row 17 in my example file the value I want returned is "AH" as the value "1" is found in the two rows with A and H in the column preceding the searched matrix.
The searched matrix can be expected to be sorted from small to large number in the individual rows. a value can be found in one or more rows.
Been trying for a while now but can't seem to nail it down.
I really want a compact formula as I'm inserting it into a larger formula and don't want it to grow beyond what I can fit.
Bookmarks