to: Alan@alan.alan: Previous Post

09-15-04, 09:29 PM

Darcie

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

09-15-04, 09:42 PM

Alan

"Darcie" <o1darcie1o> wrote in message
news:280a
>
> 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?
>

Hi Darcie,

When you create your lookup value in the VLOOKUP formula, link it to
the actual value in the 'Changes' sheet that it is looking for. That
way you can be sure that it is looking for something that *must*
exist.

If that works, then change it to whatever you had before.

If that then breaks it, you now know that what you replaced in the
formula is *not* exactly what you thought it was, and you can
invetigate from there.

HTH,

Alan.

09-15-04, 11:08 PM

John

>-----Original Message-----
>"Darcie" <o1darcie1o> wrote in message
>news:280a
>>
>> 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?
>>
>
>Hi Darcie,
>
>When you create your lookup value in the VLOOKUP formula,
link it to
>the actual value in the 'Changes' sheet that it is
looking for. That
>way you can be sure that it is looking for something that
*must*
>exist.
>
>If that works, then change it to whatever you had before.
>
>If that then breaks it, you now know that what you
replaced in the
>formula is *not* exactly what you thought it was, and you
can
>invetigate from there.
>
>HTH,
>
>Alan.
>Hi Alan,
That didn't work - I still received #N/A.
Someone else suggested it might be because one of the
number sets might be a "string" - but I don't know what
that is - can I fix it to be something VLOOKUP will read?
Thanks!
Darcie

09-15-04, 11:20 PM

Darcie

Alan - thank you for your help - I got the info from the
Knowledge base.
For anyone else who needs:

To use this method, follow these steps:
In any blank cell, enter the value 1.
Select the cell in which you typed 1 and click Copy on the
Edit menu.
Select the cells with the values that you want to convert
to numbers.
On the Edit menu, click Paste Special.
Under Operation, click Multiply. Under Paste, click
Values, and then click OK.

Thanks Alan!!!
[..]

Similar Threads
Well done, Alan! -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 From -current's Changelog: Thu Jun 14 16:39:01 CDT 2007 It's that time again, and here we have Slackware 12.0 release...
Alan Connor Greetings to my many fans! I'm still here, just using another psuedo-identity. Not as much as I used to be, though. Why? Because I finally realized that the Usenet has...
Hey Alan Ludwig... Can you at least respond to my query with "I don't know" so I can eliminate the hope or possibility of any kind of support from...
alan, I sent you a post earlier sorry i took so long to reply to your post, thank you for answering. I am pretty sure of the spelling, but I will double check. So you are saying I have a virus?, and...
ALAN In case nobody has done it here's your original post. It seem from the replies you got there's a server problem with the web interface (no surprises there) so the suggestion...