Links work in one workbook, not in another

[Clayman]

I'm using the following formula in two different workbooks:

=IF(F4=1,VLOOKUP(D4,'S:\payroll folder\[vacation
info.xls]Summary'!$B$3:$F$110,5,FALSE),VLOOKUP(D4,'S:\payroll folder\[more
vacation info.xls]Summary'!$B$4:$F$103,5,FALSE))

It is entered exactly the same way in both workbooks, but only works from
one. Note: For security reasons I changed the name of the folder and .xls
file.

In the second workbook, I get an #N/A error. In both workbooks, F4=1 and
D4=173010. The "vacation info" sheets are sorted by employee number (D4).

Any ideas?

 

[bj]

in your second workbook, what do you get with =F4=D4?
depending on how they are generated, they might not really be identical
Are they text or numeric?

 

[bj]

I thought I had answered this one, but don't see it now
what do you get when you enter =[book1]sheet1!D4=[book2]sheet1!D4
and samething for F4
they may llok alike but not really be alike

 

[Clayman]

ARGH!!!!

Yeah - that's it. One's text, the other's numeric. Thanks for the tip!

Man - getting data from "unschooled" sources... One data source is payroll,
the other data source is field supervisors. Payroll's is numeric, Supervisors
are text.
--
Adios,
Clay Harryman

I thought I had answered this one, but don't see it now
what do you get when you enter =[book1]sheet1!D4=[book2]sheet1!D4
and samething for F4
they may llok alike but not really be alike

I'm using the following formula in two different workbooks:

=IF(F4=1,VLOOKUP(D4,'S:\payroll folder\[vacation
info.xls]Summary'!$B$3:$F$110,5,FALSE),VLOOKUP(D4,'S:\payroll folder\[more
vacation info.xls]Summary'!$B$4:$F$103,5,FALSE))

It is entered exactly the same way in both workbooks, but only works from
one. Note: For security reasons I changed the name of the folder and .xls
file.

In the second workbook, I get an #N/A error. In both workbooks, F4=1 and
D4=173010. The "vacation info" sheets are sorted by employee number (D4).

Any ideas?

 

[Clayman]

heh - easy solution without reformatting everything:
=if(or(f4=1,f4="1")...
vlookup(value(d4)...

I think I'll become anti-technology and live in a cave...
--
Adios,
Clay Harryman

ARGH!!!!

Yeah - that's it. One's text, the other's numeric. Thanks for the tip!

Man - getting data from "unschooled" sources... One data source is payroll,
the other data source is field supervisors. Payroll's is numeric, Supervisors
are text.
--
Adios,
Clay Harryman

I thought I had answered this one, but don't see it now
what do you get when you enter =[book1]sheet1!D4=[book2]sheet1!D4
and samething for F4
they may llok alike but not really be alike

I'm using the following formula in two different workbooks:

=IF(F4=1,VLOOKUP(D4,'S:\payroll folder\[vacation
info.xls]Summary'!$B$3:$F$110,5,FALSE),VLOOKUP(D4,'S:\payroll folder\[more
vacation info.xls]Summary'!$B$4:$F$103,5,FALSE))

It is entered exactly the same way in both workbooks, but only works from
one. Note: For security reasons I changed the name of the folder and .xls
file.

In the second workbook, I get an #N/A error. In both workbooks, F4=1 and
D4=173010. The "vacation info" sheets are sorted by employee number (D4).

Any ideas?

 

[bj]

If(or(cave is dry,cave is wet))

heh - easy solution without reformatting everything:
=if(or(f4=1,f4="1")...
vlookup(value(d4)...

I think I'll become anti-technology and live in a cave...
--
Adios,
Clay Harryman

ARGH!!!!

Yeah - that's it. One's text, the other's numeric. Thanks for the tip!

Man - getting data from "unschooled" sources... One data source is payroll,
the other data source is field supervisors. Payroll's is numeric, Supervisors
are text.
--
Adios,
Clay Harryman

I thought I had answered this one, but don't see it now
what do you get when you enter =[book1]sheet1!D4=[book2]sheet1!D4
and samething for F4
they may llok alike but not really be alike

:

I'm using the following formula in two different workbooks:

=IF(F4=1,VLOOKUP(D4,'S:\payroll folder\[vacation
info.xls]Summary'!$B$3:$F$110,5,FALSE),VLOOKUP(D4,'S:\payroll folder\[more
vacation info.xls]Summary'!$B$4:$F$103,5,FALSE))

It is entered exactly the same way in both workbooks, but only works from
one. Note: For security reasons I changed the name of the folder and .xls
file.

In the second workbook, I get an #N/A error. In both workbooks, F4=1 and
D4=173010. The "vacation info" sheets are sorted by employee number (D4).

Any ideas?

 

[Clayman]

Cave is fairly dry - but there's this squeaking noise from the back...
--
Adios,
Clay Harryman

If(or(cave is dry,cave is wet))

heh - easy solution without reformatting everything:
=if(or(f4=1,f4="1")...
vlookup(value(d4)...

I think I'll become anti-technology and live in a cave...
--
Adios,
Clay Harryman

ARGH!!!!

Yeah - that's it. One's text, the other's numeric. Thanks for the tip!

Man - getting data from "unschooled" sources... One data source is payroll,
the other data source is field supervisors. Payroll's is numeric, Supervisors
are text.
--
Adios,
Clay Harryman


:

I thought I had answered this one, but don't see it now
what do you get when you enter =[book1]sheet1!D4=[book2]sheet1!D4
and samething for F4
they may llok alike but not really be alike

:

I'm using the following formula in two different workbooks:

=IF(F4=1,VLOOKUP(D4,'S:\payroll folder\[vacation
info.xls]Summary'!$B$3:$F$110,5,FALSE),VLOOKUP(D4,'S:\payroll folder\[more
vacation info.xls]Summary'!$B$4:$F$103,5,FALSE))

It is entered exactly the same way in both workbooks, but only works from
one. Note: For security reasons I changed the name of the folder and .xls
file.

In the second workbook, I get an #N/A error. In both workbooks, F4=1 and
D4=173010. The "vacation info" sheets are sorted by employee number (D4).

Any ideas?