multiple column index

  1. W

    Return latest date for multiple, concatenated values

    Hi, I have data pulled from various sources that ends up in a table in the following format (but with 260 rows) on a the sheet titled "Targetdatemerge" <tbody> A B C 1 Reference Milestone Date 2 ref1 M1.1 1/6/14 3 ref2 M1.1; M1.2 2/6/14 </tbody> I need to be able to find the latest...
  2. Q

    Index Match (with multiple matches across multiple columns)

    Below is the formula that I'm currently using. When entered it returns error message: "Did not find value '1300' in MATCH evaluation". What am I doing wrong? The 'Bedrooms' column (S2) should equal "3 BD From". Please advise. Thank you...
  3. N

    Index match formula to VBA Macro

    Hello Board, I am not very up to speed on using VBA Macro's and was wondering if I could get some help. I have an Index match formula that I would like to be able to use in VBA. I would like for this macro to work on the entire workbook of selected active sheets and populate a column with the...
  4. P

    Quick VLOOKUP Question

    Is there a way to use an IF statement within a VLOOKUP that will return a different column depending on user's request? Example: User selects Fund name, and Checklist Type. The VLOOKUP needs to select either 1,2,3,4 for the column index number depending on which type of Checklist is selected...

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