index function as vlookup

  1. A

    Excel formula bar: Function to return TRUE, FALSE or #NA if data in multiple columns/rows does not match

    Hello Apologies for the vague question. Hope that someone can help me with this. This is what I meant: There will be another column where it would tabulate TRUE (if the data match) or FALSE (if the data do not match). Basically, the user will continue updating the rows and columns. Based...
  2. C

    Searching multiple tabs for the value of a single cell corresponding to the tab

    I have a workbook with several tabs. Within each tab there is a single cell (O1) that has a sum in it. I have used the INDEX function to create a "Table of Contents" tab with the names of all the tabs on it. Question: What function do I use to "look" at the name of the tab created by the...
  3. C

    Choose two ranking numbers with the same value using index

    I use INDEX($C$9:$C$30,MATCH($C37,E$9:E$30,0)) to match the ranking results of a table starting in c9-c30. Their corresponding rankings are on E9-E30. I'm interested in the first six rankings from the evaluated names that are included in the table using C37 to C42 (C37 =1, c38=2, c42=6). However...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top