index(match

  1. K

    Index (Match) to locate pivot table data, based on column header and matching row item

    My active worksheet called "Estimate", includes my billing items from a formula in cells B13:B39, and a user entered month in cell M8 for the period the statement is being created for. The Pivot table is on a worksheet called "Pivot Data", and contains the information I need to summarize in...
  2. B

    index match- with & not working (Format issue?)

    Hey guys, I am using the following formula. =INDEX($I$4:$I$85,MATCH(B881&" "&C881,$H$4:$H$79,0)) Column B Part of the name: Mattamy- Column C second part of the name: James place Column H has the entire name (first and last) The index worked for some, but not for all of the names. When I...

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