How do you do this?

[Kara]

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?

 

[Gord Dibben]

Kara(or whomever)

Posting the same question under new subject and different names will not get
you help any faster.

I responded to your question over in the excel.misc group where you signed as
"Darcie"

I will respond here with same question.

"Doesn't work" means what?

Gord Dibben Excel MVP

 

[Gord Dibben]

Correction....

Same group, not other group.

Gord