formula issue

  1. Z

    Formula Evaluation Issue

    Hello, I've just encountered a strange formula evaluation issue where only two cells using a custom formula are returning #NAME? instead of the cell value it's supposed to return. The table currently has 127 records, and it's only two values where this issue is occurring even though the...
  2. H

    VLOOKUP Issue with Approximate Match - Need Help Categorizing Customers

    I'm facing an issue with the VLOOKUP function when attempting to categorize my customers based on their values. I have a list of customer names in column A and their respective values in column B. Additionally, I have a reference table with categories in column G and their corresponding values...
    • happydz
    • Thread
    • approximate match formula issue reference table vlookup
    • Replies: 9
    • Forum: Excel Questions
  3. A

    Trying to use countif formula, difficult to explain

    Hi there, I've been pulling my hair out on this one, I've got a large range about 1249 rows with 68 columns, due to privacy agreements I cant release any screenshots of the actual spreadsheet. So I have included an example below. So I need to count the conformity within the 'lemons'...
  4. M

    How do you only apply a certain formula if one of the cells is populated?

    I would like to please know how to apply a formula only when a certain cell is positive. The current formula is =(I5-(J5+K5+W5+AJ5)) but I only want the formula to be applied if there is data in I5. Hope someone can help me. Kind Regards,

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