Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help with referencing!
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? Thank you in advance for your help! Darcie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEEEEASE Help Soon!!!
-----Original Message----- 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? Thank you in advance for your help! Darcie . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing help | Excel Discussion (Misc queries) | |||
referencing a different tab by referencing a list in the current s | Excel Worksheet Functions | |||
More referencing | Excel Worksheet Functions | |||
Help with referencing a .dll | Excel Programming | |||
Row Referencing | Excel Programming |