On Tuesday, October 13, 2009 at 1:04:01 AM UTC+5:30, Summerfun wrote:
I think it is the middle dot that Quickbooks insists on using in the item description. I have to do an edit replace to get the dot out before the formulas will work. Thank you everyone for trying to help.
"Summerfun" wrote:
If I change it to FALSE it returns #N/A. I have one formula that works and the other formulas are bringing in a value from the row above.
"Summerfun" wrote:
=VLOOKUP("Total 5620 ∙ Payroll Taxes",'09 NI'!$D$5:$AB$186,23,TRUE)
I am trying to pull data from an Quickbooks excel report. This formula returns the value directly above the row that contains Total 5620 ∙ Payroll
Taxes
"T. Valko" wrote:
You'll need to post the formula with an explanation of what it's supposed to
do.
--
Biff
Microsoft Excel MVP
"Summerfun" <[email protected]> wrote in message news:[email protected]...
The VLOOKUP function is returning a value exactly one row above the row it
should be using.
In my case - the issue was that I was using a Day() function on top of the row reference i.e. Day(A2). Removing the function and simply using A2 got me the desired result.
Tip: select the section in the formula bar to peek into the evaluated value and compare it with your expected value - to debug
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)