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" wrote in message
...
The VLOOKUP function is returning a value exactly one row above the row it
should be using.