match function error

  1. A

    WorksheetFunction.Match not working for numbers

    Hi i have a piece of code that is not working correctly for numbers. it will work perfectly when the cell value has at least one letter in it, but if the cell value is only numbers it will not work. I have a very limited understanding of VBA so any help at all is very much appreciated! here...
    • Andrew1234
    • Thread
    • cell format changes match match function error vba worksheet formulas
    • Replies: 22
    • Forum: Excel Questions
  2. D

    Error in Excel with Time function within Match function

    I am trying to use the Match function to return the row of an indicated table that a certain time value is on. The time is in mm:ss format on the table, so I want users to input the desired time to match as text for their simplicity (with data validation to ensure its correct format), and then...
    • Dlark
    • Thread
    • excel time function formula match function error
    • Replies: 2
    • Forum: Excel Questions
  3. H

    Match function error

    https://drive.google.com/open?id=0B69LhOObJF1XQ2ViQVJEczducW8&authuser=0 Here is a link to my simple excel file. There is a problem in using the match function. You can edit the ranges filled with light yellow to get the results filled with sky blue. The problem is with cell F9. Even when the...

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