Matching numbers in the correct range

**fulldeen** · 10-31-2012, 10:59 AM

i am looking for a formula to match my columns numbers and go to the correct place.
here is the file
One more time Thank you .

**kbkumar** · 10-31-2012, 11:08 AM

Use this formula in cell B10, and drag it across rows and columns till AH24

Formula:

Please Login or Register  to view this content.

Hope this helps.

**fulldeen** · 10-31-2012, 11:19 AM

thank you so much my Dear kbkumar.
that was excelland.

**FDibbins** · 10-31-2012, 11:25 AM

hi
using this seems to start off getting what you want, but then im not sure where you get some other of you're answers. anyway, give it a shot.
=INDEX($A$1:$BL$9,MATCH($A10,$A$1:$BL$1,0),ROW($A1)+1)

an alternative may also be to use copy/paste transpose, depending on you're needs