Hi, can someone help me please?
excel1.PNG
I want to be able to search for a particular value in row E7:H7 and have it return the cells below as indicated on the picture attached.
HOWEVER, if I search for "B" I don't get 2,6,wait,14,18 returned because I don't know how to extend the look up value.
This is the formula I am using: =INDEX(E7:H12,MATCH($J$8,$E$7:$E$12,0)+{1,2,3,4,5},1)
Can anyone help me adjust this formula so that I can change the search value to B or C and get the following list of cells below them?
(Hope I am making myself clear enough)
Bookmarks