Help with match index two variables

[richhhh]

Kinda stuck . I have data layed out that is not ideal. In my example I need excel to find the colour blue in a list of colours and then find a number below the colour and retrieve the number below that and the number to the right . I have attached a workbook that shows in yellow what i am looking for . I would like be able to change both the colour and the number. Thank you for any help!

[Limor_OP]

In G3:
=INDEX($A$1:$A$21,MATCH(F3,A1:A21,0)+3)

I3:
=INDEX($A$1:$A$21,MATCH(F3,A1:A21,0)+4)
J3:
=INDEX($B$1:$B$21,MATCH(F3,A1:A21,0)+4)

[Phuocam]

Try this in I3:

=INDEX(A$1:A$21,MATCH(1,(ROW($A$1:$A$21)>MATCH($F$3,$A$1:$A$21,0))*($A$1:$A$21=$G$3),0)+1)

Enter with Ctrl+Shift+Enter.

[richhhh]

Thank you so much for your help but in my example the colour and the 28.5 are variables that find the two numbers in yellow. So f3 and g3 will be changed. Thank you again

[richhhh]

Thanks phunocam that did not seem to work either

[richhhh]

Wait a second that did work. Cant thank you enough. Cheers!

[richhhh]

I just need to fill in j3 now

[Pete_UK]

Put this formula in I3:

=INDEX(A:A,MATCH($F$3,$A:$A,0)+MATCH($G$3,$A$2:$A$7,0)+1)

and copy it into J3.

Hope this helps.

Pete

[richhhh]

Ok we got a winner! Thank you all for the help!!

[Pete_UK]

Thanks for the rep.

If that takes care of your original question, please click on Thread Tools immediately above your first post in this thread, and mark the thread as Solved.

Pete

[richhhh]

I went to do that at first but these were my options? Sorry been awhile?
Show Printable Version
Email this Page…
Unsubscribe from this Thread
Add a Poll to this Thread…

[Pete_UK]

There are some problems on the board at the moment - the "Mark as Solved" option seems to have been lost.

Pete