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" <Summ...@discussions.microsoft.com> wrote in message news:D349F345-267F-4465...@microsoft.com...

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)