How do I .........

[Laura]

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!

 

[mikelee]

when you say "doesn't work," do you mean you are getting
an error (i.e. #Value or #Name) or is the function
returning a value, just not the one you want?

have you made sure that you have the table_array and/or
col_index_num correct? if you are looking for exact
matches, do you have "False" for the last argument for
the vlookup function?

mike

 

[Laura]

Mike:
Two identical sheets, referencing the same original
workbook.
The vlookup that works is:
=VLOOKUP(A:A,'[PIR 08-04.xls]Complete Inventory'!$A:$B,2,0)
The problem sheet is:
=VLOOKUP(A:A,'[PIR 08-04.xls]Complete Inventory'!$A:$B,2,0)

The formatting is the same for both - they were copied &
pasted from the same original sheet.

I'm getting the #N/A message.

 

[mikelee]

hmmm...i created a PIR 08-04.xls workbook, named a sheet
Complete Inventory, then put numbers in column A and text
in column B. then i opened a new workbook and pasted
your forumla directly from your post into my new workbook
and tried it. the only way i could make it give me an
#N/A was when i told it to look up a value that i knew
wasn't in the PIR 08-04.xls workbook. since it doesn't
sound like that's the problem you're having, you might
have me stumped.
have you tried posting this to the Excel/Worksheet
Functions board? i'll keep thinking on this one, but you
might try that and see if anyone checking that group has
seen anything like this before. if anyone else reading
this has any ideas, please pipe in.
sorry i wasn't any help.

mike

-----Original Message-----
Mike:
Two identical sheets, referencing the same original
workbook.
The vlookup that works is:
=VLOOKUP(A:A,'[PIR 08-04.xls]Complete Inventory'! $A:$B,2,0)
The problem sheet is:
=VLOOKUP(A:A,'[PIR 08-04.xls]Complete Inventory'! $A:$B,2,0)

The formatting is the same for both - they were copied &
pasted from the same original sheet.

I'm getting the #N/A message.

-----Original Message-----
when you say "doesn't work," do you mean you are getting
an error (i.e. #Value or #Name) or is the function
returning a value, just not the one you want?

have you made sure that you have the table_array and/or
col_index_num correct? if you are looking for exact
matches, do you have "False" for the last argument for
the vlookup function?

mike

.

.

 

[Laura]

Hi Mike,
I've posted this question 3 times over there, but I'm
being ignored. I must have them stumped too!
Thank you so much for trying though.
Laura

-----Original Message-----
hmmm...i created a PIR 08-04.xls workbook, named a sheet
Complete Inventory, then put numbers in column A and text
in column B. then i opened a new workbook and pasted
your forumla directly from your post into my new workbook
and tried it. the only way i could make it give me an
#N/A was when i told it to look up a value that i knew
wasn't in the PIR 08-04.xls workbook. since it doesn't
sound like that's the problem you're having, you might
have me stumped.
have you tried posting this to the Excel/Worksheet
Functions board? i'll keep thinking on this one, but you
might try that and see if anyone checking that group has
seen anything like this before. if anyone else reading
this has any ideas, please pipe in.
sorry i wasn't any help.

mike

-----Original Message-----
Mike:
Two identical sheets, referencing the same original
workbook.
The vlookup that works is:
=VLOOKUP(A:A,'[PIR 08-04.xls]Complete Inventory'! $A:$B,2,0)
The problem sheet is:
=VLOOKUP(A:A,'[PIR 08-04.xls]Complete Inventory'! $A:$B,2,0)

The formatting is the same for both - they were copied &
pasted from the same original sheet.

I'm getting the #N/A message.

-----Original Message-----
when you say "doesn't work," do you mean you are getting
an error (i.e. #Value or #Name) or is the function
returning a value, just not the one you want?

have you made sure that you have the table_array and/or
col_index_num correct? if you are looking for exact
matches, do you have "False" for the last argument for
the vlookup function?

mike

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

.

.

.

.

 

[Laura]

Mike -
I tried the programming board, and Jim got me far enough
to use the knowledge base.
Because the sheets are originally dumps out of another
system, they converted to strings after the initial
vlookup. I fixed them with the paste special with
multiply and it's working!!!
Thank you again!!!

-----Original Message-----
Hi Mike,
I've posted this question 3 times over there, but I'm
being ignored. I must have them stumped too!
Thank you so much for trying though.
Laura

-----Original Message-----
hmmm...i created a PIR 08-04.xls workbook, named a sheet
Complete Inventory, then put numbers in column A and text
in column B. then i opened a new workbook and pasted
your forumla directly from your post into my new workbook
and tried it. the only way i could make it give me an
#N/A was when i told it to look up a value that i knew
wasn't in the PIR 08-04.xls workbook. since it doesn't
sound like that's the problem you're having, you might
have me stumped.
have you tried posting this to the Excel/Worksheet
Functions board? i'll keep thinking on this one, but you
might try that and see if anyone checking that group has
seen anything like this before. if anyone else reading
this has any ideas, please pipe in.
sorry i wasn't any help.

mike

-----Original Message-----
Mike:
Two identical sheets, referencing the same original
workbook.
The vlookup that works is:
=VLOOKUP(A:A,'[PIR 08-04.xls]Complete Inventory'! $A:$B,2,0)
The problem sheet is:
=VLOOKUP(A:A,'[PIR 08-04.xls]Complete Inventory'! $A:$B,2,0)

The formatting is the same for both - they were copied &
pasted from the same original sheet.

I'm getting the #N/A message.

-----Original Message-----
when you say "doesn't work," do you mean you are getting
an error (i.e. #Value or #Name) or is the function
returning a value, just not the one you want?

have you made sure that you have the table_array and/or
col_index_num correct? if you are looking for exact
matches, do you have "False" for the last argument for
the vlookup function?

mike

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

.

.

.

.

.

 

[Gord Dibben]

Hi there Laura, Darcie, Kara, Jackie, anonymous.

Good to see you're still around.

Gord Dibben Excel MVP