incorrect value returned

Hello, Apologies but my work won't allow XL2BB for security reasons. The formula in column G is: =IFERROR(SUM(F9-C9)/F9, "") This returns a percentage increase or decrease between the figures in columns F and C. However, the exact same formula in column J: =IFERROR(SUM(I9-F9)/I9, "")...

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...

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...

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...

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

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...

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...