match function

  1. G

    INDEX - INDIRECT - MATCH Functions

    Finally breaking down and asking for help with the following function/brick wall. I'm currently using the match function to look up a dollar amount per insulation diameter and thickness. Each different tab is a different type of insulation. I've always had to hardcode in the "Tab Worksheet...
  2. S

    Exact Match Function Based on Letter Case

    Hello All, Does anyone know if you can create a Match Function that only finds an Exact Case match? My Data has records thar are unique in the system, but may not appear unique in excel matching terms. Record 1 ID: 0016000000g2upN Record 2 ID: 0016000000g2upn When performing an exact...
  3. D

    ABS Function and Named Array Formulas to Find Closest Value

    Hi All, I am really struggling with the following formula: MATCH(MIN(ABS(Ann_TaylorRegularBust-B4)),ABS(Ann_TaylorRegularBust-B4),0) I am trying to find the cell in the named row "Ann_TaylorRegularBust" that is closest to the input bust size in cell B4. This formula works when I use actual...
  4. F

    Use Excel to return a single value based on a range?

    I need to pull a value from one sheet and put it on another based on a range of 1-40. In column F I have F4:F43 (Total 40). In Column A I have A4:A43 (Total 40). What i need to do is return the value from A to a separate sheet based on the value in F. This is made difficult because currently...
  5. I

    'Near search' function in excel?

    PLease help me out with this problem! It seems simple yet I can't do anything about it. I have 3 lists of company names that I have acquired from three different sources. The companies mentioned are the same in each of the lists (the lists may have few additional names as well), but since I...
  6. N

    Search and combining row and column data

    Search and combining row and column data <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have been working on this with one other guy for the majority of the day and wondering if anyone has any insight. <TABLE style="WIDTH: 319pt; BORDER-COLLAPSE...
  7. S

    Date Match Problem

    Hey all, I am trying to find the column number where a certain date is located using the match function but I am getting errors. My code: Dim sDate, As Long Dim st As Date st = formMissingTime.txtStartDate.Value sDate = Application.Match(st, Range("J2:AAA2"), 0) Range(Columns(sDate)).Select...
  8. S

    Using Match function

    Given a data range in ascending order(This condition cannot be changed), how can one use the match() function to find the row no. of a particular no. in the data range that is greater than or equal to the no. that is searched for.
  9. M

    MATCH function - match_type question

    Hi, MATCH(lookup_value,lookup_array,match_type) I am using the MATCH function to specify in which row of a large table I want to be looking up values. The column I am MATCH-ing contains numbers in ascending order. For smaller values, the increment is 0.1 , then 0.5, finally the numbers are...
  10. S

    Finding more than 1 instance of text in a list

    I'm setting up a workbook in Excel 2007 which imports the year's data from Sage Accounts and uses that data to produce P&L Account, Balance Sheet and Cashflow acctuals and budget to the end of the year. My problem is with a floating account in the Balance Sheet, ie an account which can be...
  11. D

    Match function nested in an If statement

    I have an excel file with multiple sheets. Column A represents names. The sheets will have varying numbers of names, for example, on sheet one there may be a "smith" in row 3, but because on sheet 2 there may be additional names, the same "smith" may be in row 5. Column B depicts growth...
  12. P

    Match, cut & Paste

    <TABLE style="WIDTH: 213pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=284 border=0 x:str><COLGROUP><COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 5449" width=149><COL style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4937" width=135><TBODY><TR...
  13. S

    Conditional Formatting for column using Match and named range

    Hello, Is there a way to "copy down" for conditional formatting in a column? For example, I have the following rule for conditional formatting for a cell: =MATCH($A2,myNamedRange,0) I have a column of over 7000 cells, I would like to be able to conditionally format for each of cells where each...

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