to: [email protected]: Previous Post

[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

 

[Alan]

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.

 

[Guest]

-----Original Message-----


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

 

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