Index/Match HELP!!!

R

Russ

I am trying to get values plugged into columns and rows as they are entered in top section of the spreadsheet, placed elsewhere on a hidden section of the sheet. Product names are: "Horn", "Light", "Peddle" etc, etc, etc. What I want to accomplish is, I guess simple enough, however, I am having a devil of a time to get this to work correctly. The "C11:C61" column is the product column on which the search is being done for the various products, the record's width is from A11 through AZ11. I want to place each product grouped within it's own range for product calculation reasons. Here is the function below. It is failing, and not working properly. Can someone check it for accuracy? It is a mix of Index and Match.

=INDEX(A11:C61,MATCH("Horn";C11:C61,0),1)

If there is a new record entered for "Horn" as a value in "C11", automatically plug entire record (A11:AZ11) in the hidden range named: "product_Horn" chronoligically. If the next product is: "Light" as a value in "C12", automatically plug entire record (A12:AZ12) in the hidden range named: "product_Light" chronoligically and so on and so on. The formula above does not seen to work can someone assist?

Thanks,.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

roundup with index,match,subtract,divide and add formula 3
Convert Number to Text for Index/Match 1
Index and Match 8
Formula Reference Error, HELP! 2
help on a formula (match and etc..) 1
vlookup or index/match formula?? 2
Index, Match help 6
Adding OR to an index match formula 2

Top