index multiple columns

  1. A

    Index Match problem with link to another file

    Hello Gurus, I got this formula: The answer should be 1. But it is giving result = 4. It is supposed to look for "RDO" in the row with the person's name in column E and give me the result if there is one in any of the cells in that row between columns H and AJ. There will never be more...
  2. E

    How to populate cell based on multiple criteria from another workbook

    :confused: My Problem is as follows: In Workbook 1 I will enter two pieces of data. In cell A1 I will enter (County Name) and In cell B2 (Plan Number). In Workbook 2 I have a database as follows: Col1=PlanNumber Col2=County Col3=Value. I need to populate cell B3 in workbook 1 with matching...
  3. A

    Index Matching against multiple columns

    Hi there, I am a relative novice at all this, so please bear with me. I have a spread sheet where i want to check a serial number against 2 possible columns that it would be in and then return the name of the person it has been issed to. At the moment i have it sorted that it will look in one...
  4. B

    Index - Match - 1 Criteria - 2 columns - 2 files

    Hello...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I need a little bit help... I think this is an Index - Match scenario, but I am not too clear on how to make it work.<o:p></o:p> <o:p></o:p> I have 2 files, one is the "Data File" and the other file...
  5. H

    Formula to Indexing multiple columns

    Formula to Index multiple columns I have a sheet consisting of the following three columns. Column A = Customer Number Column B = Month/Year Column C = -1 (This is a special indicator that does not appear each month) I am trying to write a formula that would find the first “Month/Year”...

Watch MrExcel Video

This Week's Hot Topics

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
Top