Why is VLOOKUP returning a value from the row above?
 

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

Why is VLOOKUP returning a value from the row above?
 

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.

Why is VLOOKUP returning a value from the row above?
 

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

On Oct 12, 6:48*pm, Summerfun
wrote:
The VLOOKUP function is returning a value exactly one row above the row it
should be using.

Why is VLOOKUP returning a value from the row above?
 

Be sure to include the False:

=VLOOKUP(something, some_array, some_column, FALSE)
--
Gary''s Student - gsnu200907


"Summerfun" wrote:

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

Why is VLOOKUP returning a value from the row above?
 

Post your formula.

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

=VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)

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


If this post helps click Yes
---------------
Jacob Skaria


"Summerfun" wrote:

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

Why is VLOOKUP returning a value from the row above?
 

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

Why is VLOOKUP returning a value from the row above?
 

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.

Why is VLOOKUP returning a value from the row above?
 

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