incorrect value returned

  1. J

    vlookup returns some correct values, some #n/a and some incorrect values

    I'm doing a simple vlookup between two tabs in the same spreadsheet. Many returned values have #n/a but when I search the second tab they appear in the table. Some of the values are correct and some even return an incorrect value. Please help. I've had to manually lookup over 100 values in...
  2. D

    Excel 2007 linked to Access 2007 query pulls default of query formula instead of correct answer

    Hello - first post here. I have a spreadsheet in Excel 2007 that is pulling from a query built in Access 2007. The formula in the query reads: RetireElig: IIf([age]>=65 And [ServiceYrs]>=10,"65 & 110",IIf([age]>=60 And [ServiceYrs]>=15,"60 & 15",IIf([Age]>=55 And...
  3. T

    LOOKUP Formula not returning correct value from array

    Hi, I have a spreadsheet with some data, alongside each entry in the list is a month in "MMM" format. I want to lookup this value and return the full month using a LOOKUP formula. It used to use a VLOOKUP from another table but I want to get rid of this additional table. Basically my...
  4. D

    Pivot Table Results Are Huge

    Pivot table results (using SUM) are huge - not the numbers displayed in the underlying table. If I use COUNT, they are too small. Please advise. DOUG in Wichita KS
  5. ClimoC

    Userform - El Loco

    Hello Had some handy code working, and then to make things neat and tidy and easier to give to users across the network, I've moved it all into a userform. Upon clicking the button, it should open an inputbox, take the answer as a string, and use it to find a folder of that name where some...
  6. A

    Vlookup does not return correct value

    I have a Vlookup challenge which I can´t seem to solve myself. Does anybody have a solution? Matrix defined by AB3:AC26 Format of the column AB is TEXT, of AC is GENERAL Cell F17 contains a Data Validation Drop-Down with source data the matrix AB2:AB26 (including a blank cell AB2). I have a...

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