0
Return Adjacent Cell after Index-Match function
I am trying to search a column in excel based on a string value and return the contents of the cell below it. The formula I currently have is returning the contents of the indexed cell, but I would like it to return the contents of the cell below instead. A summary of the code as is: =INDEX('Sheet4'!A:A,MATCH("*"&A2&"*",'Sheet4'!A:A,0),1,1)
1 Answer
0
For anyone who may need the answer, I've figured it out. I replaced the "1,1)" with "+1)"