Return Adjacent Cell after Index-Match function | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
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)

28th Oct 2019, 1:00 PM
George S
1 Answer
0
For anyone who may need the answer, I've figured it out. I replaced the "1,1)" with "+1)"
28th Oct 2019, 5:16 PM
George S