S
Summerfun
The VLOOKUP function is returning a value exactly one row above the row it
should be using.
should be using.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
You'll need to post the formula with an explanation of what it's supposed to
do.
do.
P
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
VLOOKUP function and set it to 0 or FALSE.
Hope this helps.
Pete
G
Gary''s Student
Be sure to include the False:
=VLOOKUP(something, some_array, some_column, FALSE)
=VLOOKUP(something, some_array, some_column, FALSE)
J
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
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
S
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
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
S
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.
the other formulas are bringing in a value from the row above.
S
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.
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.