tab name

  • Thread starter Thread starter puiuluipui
  • Start date Start date
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.


Thanks in advance!
 
=IF(B5<>"",IF(ISNA(VLOOKUP($B5,INDIRECT("'"&A1&"'!$B$4:$G$593"),6,FALSE)),"??",VLOOKUP($B5,INDIRECT("'"&A1&"'!$B$4:$G$593"),6,FALSE)),"")
 
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:
 
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:
 
=IF(B5<>"",IF(ISNA(VLOOKUP($B5,INDIRECT("'"&A1&"'!$B$4:$G$593"),6,FALSE)),"No","OK"),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula question 2
IF,AND... 1
parenthesis 1
2 FORMULA IN 1 4
Retrieving info from multiple tables 1
Vlookups and formats 3
Help with VLOOKUP? 1
sumproduct or sumif? 3

Back
Top