| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tab name
Hy, i have this formula :
=IF(B5<"",IF(ISNA(VLOOKUP($B5,PLANNING!$B$4:$G$59 3,6,FALSE)),"??",VLOOKUP($B5,PLANNING!$B$4:$G$593, 6,FALSE)),"") "PLANNING" = an tab name. I need something like this ( "A1" instead of "PLANNING": =IF(B5<"",IF(ISNA(VLOOKUP($B5,A1!$B$4:$G$593,6,FA LSE)),"??",VLOOKUP($B5,A1!$B$4:$G$593,6,FALSE)),"" ) "A1" = cell And in "A1" to write an tab name. (planning ; monday ; tuesday...etc) "A1" content to replace "PLANNING" from formula. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab name
=IF(B5<"",IF(ISNA(VLOOKUP($B5,INDIRECT("'"&A1&"'! $B$4:$G$593"),6,FALSE)),"??",VLOOKUP($B5,INDIRECT( "'"&A1&"'!$B$4:$G$593"),6,FALSE)),"")
-- __________________________________ HTH Bob "puiuluipui" wrote in message ... Hy, i have this formula : =IF(B5<"",IF(ISNA(VLOOKUP($B5,PLANNING!$B$4:$G$59 3,6,FALSE)),"??",VLOOKUP($B5,PLANNING!$B$4:$G$593, 6,FALSE)),"") "PLANNING" = an tab name. I need something like this ( "A1" instead of "PLANNING": =IF(B5<"",IF(ISNA(VLOOKUP($B5,A1!$B$4:$G$593,6,FA LSE)),"??",VLOOKUP($B5,A1!$B$4:$G$593,6,FALSE)),"" ) "A1" = cell And in "A1" to write an tab name. (planning ; monday ; tuesday...etc) "A1" content to replace "PLANNING" from formula. Thanks in advance! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab name
THANKS ALLOT!
it's working! Thanks. "Bob Phillips" a scris: =IF(B5<"",IF(ISNA(VLOOKUP($B5,INDIRECT("'"&A1&"'! $B$4:$G$593"),6,FALSE)),"??",VLOOKUP($B5,INDIRECT( "'"&A1&"'!$B$4:$G$593"),6,FALSE)),"") -- __________________________________ HTH Bob "puiuluipui" wrote in message ... Hy, i have this formula : =IF(B5<"",IF(ISNA(VLOOKUP($B5,PLANNING!$B$4:$G$59 3,6,FALSE)),"??",VLOOKUP($B5,PLANNING!$B$4:$G$593, 6,FALSE)),"") "PLANNING" = an tab name. I need something like this ( "A1" instead of "PLANNING": =IF(B5<"",IF(ISNA(VLOOKUP($B5,A1!$B$4:$G$593,6,FA LSE)),"??",VLOOKUP($B5,A1!$B$4:$G$593,6,FALSE)),"" ) "A1" = cell And in "A1" to write an tab name. (planning ; monday ; tuesday...etc) "A1" content to replace "PLANNING" from formula. Thanks in advance! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab name
Hy, i have a small problem. some tab names are "05.01.2009 ; 06.01.2009...etc"
The formula doesn't work with dates. Can you help me? "Bob Phillips" a scris: =IF(B5<"",IF(ISNA(VLOOKUP($B5,INDIRECT("'"&A1&"'! $B$4:$G$593"),6,FALSE)),"??",VLOOKUP($B5,INDIRECT( "'"&A1&"'!$B$4:$G$593"),6,FALSE)),"") -- __________________________________ HTH Bob "puiuluipui" wrote in message ... Hy, i have this formula : =IF(B5<"",IF(ISNA(VLOOKUP($B5,PLANNING!$B$4:$G$59 3,6,FALSE)),"??",VLOOKUP($B5,PLANNING!$B$4:$G$593, 6,FALSE)),"") "PLANNING" = an tab name. I need something like this ( "A1" instead of "PLANNING": =IF(B5<"",IF(ISNA(VLOOKUP($B5,A1!$B$4:$G$593,6,FA LSE)),"??",VLOOKUP($B5,A1!$B$4:$G$593,6,FALSE)),"" ) "A1" = cell And in "A1" to write an tab name. (planning ; monday ; tuesday...etc) "A1" content to replace "PLANNING" from formula. Thanks in advance! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab name
Maybe you need to format them, so instead of A1 try TEXT(A1,"mm.dd.yy")
-- __________________________________ HTH Bob "puiuluipui" wrote in message ... Hy, i have a small problem. some tab names are "05.01.2009 ; 06.01.2009...etc" The formula doesn't work with dates. Can you help me? "Bob Phillips" a scris: =IF(B5<"",IF(ISNA(VLOOKUP($B5,INDIRECT("'"&A1&"'! $B$4:$G$593"),6,FALSE)),"??",VLOOKUP($B5,INDIRECT( "'"&A1&"'!$B$4:$G$593"),6,FALSE)),"") -- __________________________________ HTH Bob "puiuluipui" wrote in message ... Hy, i have this formula : =IF(B5<"",IF(ISNA(VLOOKUP($B5,PLANNING!$B$4:$G$59 3,6,FALSE)),"??",VLOOKUP($B5,PLANNING!$B$4:$G$593, 6,FALSE)),"") "PLANNING" = an tab name. I need something like this ( "A1" instead of "PLANNING": =IF(B5<"",IF(ISNA(VLOOKUP($B5,A1!$B$4:$G$593,6,FA LSE)),"??",VLOOKUP($B5,A1!$B$4:$G$593,6,FALSE)),"" ) "A1" = cell And in "A1" to write an tab name. (planning ; monday ; tuesday...etc) "A1" content to replace "PLANNING" from formula. Thanks in advance! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab name
It's working now, but one last question.
If i have in B5 "adrian" and in the "planning" tab or another tab, i have"adrian" too, can the formula show "OK"? I don't wont the formula to show the next cell, only to say to me that "adrian it's in "planning". Or "NO" if the formula can't find that name. Thanks allot! "Bob Phillips" a scris: Maybe you need to format them, so instead of A1 try TEXT(A1,"mm.dd.yy") -- __________________________________ HTH Bob "puiuluipui" wrote in message ... Hy, i have a small problem. some tab names are "05.01.2009 ; 06.01.2009...etc" The formula doesn't work with dates. Can you help me? "Bob Phillips" a scris: =IF(B5<"",IF(ISNA(VLOOKUP($B5,INDIRECT("'"&A1&"'! $B$4:$G$593"),6,FALSE)),"??",VLOOKUP($B5,INDIRECT( "'"&A1&"'!$B$4:$G$593"),6,FALSE)),"") -- __________________________________ HTH Bob "puiuluipui" wrote in message ... Hy, i have this formula : =IF(B5<"",IF(ISNA(VLOOKUP($B5,PLANNING!$B$4:$G$59 3,6,FALSE)),"??",VLOOKUP($B5,PLANNING!$B$4:$G$593, 6,FALSE)),"") "PLANNING" = an tab name. I need something like this ( "A1" instead of "PLANNING": =IF(B5<"",IF(ISNA(VLOOKUP($B5,A1!$B$4:$G$593,6,FA LSE)),"??",VLOOKUP($B5,A1!$B$4:$G$593,6,FALSE)),"" ) "A1" = cell And in "A1" to write an tab name. (planning ; monday ; tuesday...etc) "A1" content to replace "PLANNING" from formula. Thanks in advance! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tab name
=IF(B5<"",IF(ISNA(VLOOKUP($B5,INDIRECT("'"&A1&"'! $B$4:$G$593"),6,FALSE)),"No","OK"),"")
-- __________________________________ HTH Bob "puiuluipui" wrote in message ... It's working now, but one last question. If i have in B5 "adrian" and in the "planning" tab or another tab, i have"adrian" too, can the formula show "OK"? I don't wont the formula to show the next cell, only to say to me that "adrian it's in "planning". Or "NO" if the formula can't find that name. Thanks allot! "Bob Phillips" a scris: Maybe you need to format them, so instead of A1 try TEXT(A1,"mm.dd.yy") -- __________________________________ HTH Bob "puiuluipui" wrote in message ... Hy, i have a small problem. some tab names are "05.01.2009 ; 06.01.2009...etc" The formula doesn't work with dates. Can you help me? "Bob Phillips" a scris: =IF(B5<"",IF(ISNA(VLOOKUP($B5,INDIRECT("'"&A1&"'! $B$4:$G$593"),6,FALSE)),"??",VLOOKUP($B5,INDIRECT( "'"&A1&"'!$B$4:$G$593"),6,FALSE)),"") -- __________________________________ HTH Bob "puiuluipui" wrote in message ... Hy, i have this formula : =IF(B5<"",IF(ISNA(VLOOKUP($B5,PLANNING!$B$4:$G$59 3,6,FALSE)),"??",VLOOKUP($B5,PLANNING!$B$4:$G$593, 6,FALSE)),"") "PLANNING" = an tab name. I need something like this ( "A1" instead of "PLANNING": =IF(B5<"",IF(ISNA(VLOOKUP($B5,A1!$B$4:$G$593,6,FA LSE)),"??",VLOOKUP($B5,A1!$B$4:$G$593,6,FALSE)),"" ) "A1" = cell And in "A1" to write an tab name. (planning ; monday ; tuesday...etc) "A1" content to replace "PLANNING" from formula. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
