Why is VLOOKUP returning a value from the row above?

[Summerfun]

The VLOOKUP function is returning a value exactly one row above the row it
should be using.

 

[T. Valko]

You'll need to post the formula with an explanation of what it's supposed to
do.

 

[Pete_UK]

If you want an exact match then you need to use a 4th parameter in the
VLOOKUP function and set it to 0 or FALSE.

Hope this helps.

Pete

 

[Gary''s Student]

Be sure to include the False:

=VLOOKUP(something, some_array, some_column, FALSE)

 

[Jacob Skaria]

Post your formula.

Set the last range_kookup to 0 or FALSE for an exact match....

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

as
=VLOOKUP(lookup_value,table_array,col_index_num,0)


If this post helps click Yes

 

[Summerfun]

=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

 

[Summerfun]

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]

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.