INDEX/MATCH formula question
 

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

INDEX/MATCH formula question
 

Assuming source table contains 4 columns (A2:D100). Assuming you always
look up the first column. Assuming Lookup value in E2.

Select an array of 4 horizontal cells (e.g. F2:I2). With 4 cells
selected:

=INDEX(A2:A100,MATCH(E2,A2:A100,0),0)

Enter with Ctrl+Shift+Enter (array formula)

HTH
Kostis Vezerides


A.S. wrote:
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