Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Why is VLOOKUP returning a value from the row above?

1,895 views
Skip to first unread message

Summerfun

unread,
Oct 12, 2009, 1:48:11 PM10/12/09
to
The VLOOKUP function is returning a value exactly one row above the row it
should be using.

Pete_UK

unread,
Oct 12, 2009, 1:52:23 PM10/12/09
to
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 <Summer...@discussions.microsoft.com>
wrote:

T. Valko

unread,
Oct 12, 2009, 1:52:12 PM10/12/09
to
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...

Jacob Skaria

unread,
Oct 12, 2009, 1:58:01 PM10/12/09
to
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
---------------
Jacob Skaria

Gary''s Student

unread,
Oct 12, 2009, 1:57:02 PM10/12/09
to
Be sure to include the False:

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

Summerfun

unread,
Oct 12, 2009, 2:57:01 PM10/12/09
to
=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

unread,
Oct 12, 2009, 3:02:10 PM10/12/09
to
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

unread,
Oct 12, 2009, 3:34:01 PM10/12/09
to
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.

Ujjwal Singh

unread,
Aug 30, 2023, 3:58:14 PM8/30/23
to
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
0 new messages