VLOOKUP gives incorrect info

  • Thread starter Thread starter hailnorm
  • Start date Start date
H

hailnorm

I have a "master" file that is a chart of accounts which is sorted in
specific order.

Each week I download a report containing the account name & sale
figures for that week. I do a VLOOKUP in the "master" account so tha
the weekly sales figures are next to the account name.

The VLOOKUP works fine in that the correct numbers are next to thei
respective account name. But accounts that shouldn't have sales number
do have numbers. Every account in the "master" file has a sales figure
when only a few accounts should have sales numbers.

What am I doing wrong? Is there some other formula that's suited fo
this task
 
Add FALSE as the fourth argument to your VLOOKUP() function - when the
argument is missing or TRUE, VLOOKUP returns the lookup value, or value
closest, to but less than, the lookup value.

VLOOKUP(lvalue, Table, 2, FALSE)

See XL Help for details
 
Back
Top