Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links work in one workbook, not in another
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:\payro ll 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? -- Adios, Clay Harryman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links work in one workbook, not in another
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? "Clayman" wrote: 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:\payro ll 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? -- Adios, Clay Harryman |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links work in one workbook, not in another
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" wrote: 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:\payro ll 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? -- Adios, Clay Harryman |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links work in one workbook, not in another
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 "bj" wrote: 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" wrote: 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:\payro ll 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? -- Adios, Clay Harryman |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links work in one workbook, not in another
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 "Clayman" wrote: 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 "bj" wrote: 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" wrote: 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:\payro ll 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? -- Adios, Clay Harryman |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links work in one workbook, not in another
If(or(cave is dry,cave is wet))
"Clayman" wrote: 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 "Clayman" wrote: 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 "bj" wrote: 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" wrote: 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:\payro ll 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? -- Adios, Clay Harryman |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links work in one workbook, not in another
Cave is fairly dry - but there's this squeaking noise from the back...
-- Adios, Clay Harryman "bj" wrote: If(or(cave is dry,cave is wet)) "Clayman" wrote: 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 "Clayman" wrote: 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 "bj" wrote: 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" wrote: 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:\payro ll 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? -- Adios, Clay Harryman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
My links to another workbook don't work | Excel Discussion (Misc queries) | |||
DO NOT update links doesn't work for me. | Excel Discussion (Misc queries) | |||
links within excel don't work when workbook is e-mailed - why ? | Excel Discussion (Misc queries) | |||
My links no longer work . . . | Excel Discussion (Misc queries) |