# tab name

P

#### puiuluipui

Hy, i have this formula
=IF(B5<>"",IF(ISNA(VLOOKUP(\$B5,PLANNING!\$B\$4:\$G\$593,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,FALSE)),"??",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.

B

#### Bob Phillips

=IF(B5<>"",IF(ISNA(VLOOKUP(\$B5,INDIRECT("'"&A1&"'!\$B\$4:\$G\$593"),6,FALSE)),"??",VLOOKUP(\$B5,INDIRECT("'"&A1&"'!\$B\$4:\$G\$593"),6,FALSE)),"")

P

#### puiuluipui

THANKS ALLOT!
it's working!
Thanks.

"Bob Phillips" a scris:

P

#### puiuluipui

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:

B

#### Bob Phillips

Maybe you need to format them, so instead of A1 try TEXT(A1,"mm.dd.yy")

P

#### puiuluipui

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:

B

#### Bob Phillips

=IF(B5<>"",IF(ISNA(VLOOKUP(\$B5,INDIRECT("'"&A1&"'!\$B\$4:\$G\$593"),6,FALSE)),"No","OK"),"")

P

#### puiuluipui

Thanks. It's working. Thanks.

"Bob Phillips" a scris: