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

"Darcie" <(E-Mail Removed)> wrote in message
news:040701c49b62$b1fdff50$(E-Mail Removed)...
>
> 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.

>-----Original Message-----
>"Darcie" <(E-Mail Removed)> wrote in message
>news:040701c49b62$b1fdff50$(E-Mail Removed)...
>>
>> 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

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!!!

>-----Original Message-----
>
>>-----Original Message-----
>>"Darcie" <(E-Mail Removed)> wrote in message
>>news:040701c49b62$b1fdff50$(E-Mail Removed)...
>>>
>>> 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
>.
>