Most valuable professional
  • Hot Topics

Excel Can INDEX functions be Variable?

Hi, Hi, I?ve had many happy years enjoying VLOOKUP, but now I?vemoved on to a deeper relationship with INDEX MATCH ;o) I am using INDEX MATCH to return values from a table with 54columns. There are 3 criteria to MATCH - MATCH expressions are variable ? they are taken from dependentdrop down lists in cells C6, C12 and C9 An example of my inelegant but working formula is: False

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of January 15, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel