Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

How to use the index function in excel?

I am having a hard time trying to figure out how to use the index function for the data listed below:

TOOL --AVG # of TESTS -- AVG COST per TEST

X 10 $2,909.55

Y 3 $913.16

Z 5 $1,088.24

Thanks for the help....

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    I have no idea what you are asking for but here's a good tutorial on using the INDEX function with the MATCH function

    Worksheet Functions -- INDEX / MATCH

    http://www.contextures.com/xlFunctions03.html

  • 5 years ago

    a varible for index is an integer. what's a bucle? and what are you trying to change?

Still have questions? Get your answers by asking now.