Is there any way to use index match so that it matches and copies everything
to the right of the match? For example, I am matching the number 1 from the
first columnin sample data below, which are all in different cells:

232 22.23 23 .029
121 8.56 11 .122
1 12.23 9 .563
928 56.34 78 .198

So in this case, I would get the formula to give me: 1 12.23 9 .563

Thanks