Jim,
I did a replace of any/all blanks (up to 4 spaces) and the
vlookup still returns a #N/A. The problem I have with
this is that I took the original sheet & copied to the
Inventory & Changes. I made no changes to either, and am
attempting the exact same thing on both, but it only works
on one!
Is there some kind of formula that will look up from one
sheet to the other & populate the next few cells?
Thanks - Jodi


-----Original Message-----
The info that comes in the report I assume is a dump out
of some accounting
system or another. Quite often when data is dumped out it
will have trailing
blank characters. Vlookup will not find exact matches
because of the trailing
blanks. Do a find and replace on the blank, replacing
with nothing. Vlookup
won't match "Dog" in one cell with "Dog " in another...

If you need to maintain some blank characters in the
middle of the strings
then you will need to write a quick little macro that
Trims the blanks from
the end. This can also be useful if this is something
that you will need to
do on a regular basis... I fyou need help with something
like this post a
reply.

Hope this works for you...

"Jodi" wrote:

I have a report that gets updated monthly. Some info
comes
in the report, the rest I have to put in.

I take my original report and copy it to two worksheets
within the workbook (Original, Changes, Inventory). On
one sheet (Inventory), I can vlookup information from
the
previous month's report, and it fills it in. Vlookup
doesn't work on the other sheet (Changes), even though
there are no formatting differences, using same report
from previous month.

Col a = company number
col's b-h need to be filled in identically to all other
months based on the company number (column mapping is
the
same).
Is there an IF function that would do this ? Or why
will
vlookup work on the other sheet & not this one?


.