lookup match

  1. V

    Find 2nd instance of a best rate within a row

    Is there a way to look up the second occurrence of a value in a row? https://drive.google.com/file/d/0B0392ULavezpbktIY29ST3kzWVU/view?usp=sharing I've created an example on the link above - hopefully you can access it. I have staff names across the column headings, and the data in the rows...
  2. G

    Lookup Data from two different tables and match on a third

    I'm trying to see if excel can automatically match names from one sheet based on criteria from another sheet to a third The first Page "Routes Previous" contains where the drivers have been before The second page "DA Available" contains the name of the drivers available for next day The third...
  3. C

    HOW TO ACCOMPLISH a vba IF/THEN FILTER? example is attached

    My current code is pulling too much; need to incorporate this filtering step ASAP but not sure how to accomplish?: Attached small sample for your viewing to help expedite understanding>: https://app.box.com/s/2h3dhbnsmgcw2rq0soa1 THERE ARE 2 PHASES: 1st Phase, DETERMINE WHAT CODE SHOULD BE...
  4. C

    SEARCH driven Input Box - Need to adjust code to include better Copy/Paste functionality

    I'm using this code to perform a lookup, match, copy/paste to another sheet within the same wrkbk. It has come to my attn that there are a couple scenarios where this won't be able to handle a couple of tricky scenarios - hence the need to adjust quickly... (add a filter) (this code is triggered...

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