Cell Address - display next column cell content

[Rubber Beaked Woodpecker]

Hi

I use the following formula that returns a cell address

=CELL("address",INDEX($N$1:$N$1500,MATCH("*"&LEFT(S30,SEARCH("-",S30)-2)&"*",$N$1:$N$1500,0)))

This returns the cell address $N$65 which is correct.

However I would like to modify the formula so that instead of returning the cell address of $N$65 the formula would return the cell content of the same row but the next column i.e the contents of $O$65

Hope this makes sense

RBW.

 

[Fluff]

How about

=INDEX($O$1:$O$1500,MATCH("*"&LEFT(S30,SEARCH("-",S30)-2)&"*",$N$1:$N$1500,0))