Creating a worksheet with values based on a control cell
 

Hello, I hope you can help.

I have a basic table with many rows but only four columns.
I have hidden this table from view and created a drop down
list so that column A is fixed based only on information
that is valid, because I put it there. What I want to
happen then is that columns B, C and D will update their
content directly based upon the data selected in column A.
Effectively the table will be duplicated but only for the
row of interest.

Thanks in advance,

Dan

Creating a worksheet with values based on a control cell
 

Hi
use VLOOKUP for this (if column A contains unique values.). e.g. in B1
on your second sheet enter
=IF(A1<"",VLOOKUP(A1,'hidden_sheet'!$A$1:$D$100,2 ,0),"")

--
Regards
Frank Kabel
Frankfurt, Germany


Dan Eames wrote:
Hello, I hope you can help.

I have a basic table with many rows but only four columns.
I have hidden this table from view and created a drop down
list so that column A is fixed based only on information
that is valid, because I put it there. What I want to
happen then is that columns B, C and D will update their
content directly based upon the data selected in column A.
Effectively the table will be duplicated but only for the
row of interest.

Thanks in advance,

Dan

Creating a worksheet with values based on a control cell
 

Frank,

Thanks for your help. Is there a maximum number of IF's I
can use becuase I will have to brake down my column A data
if there is.

Thanks,

Dan



-----Original Message-----
Hi
use VLOOKUP for this (if column A contains unique
values.). e.g. in B1
on your second sheet enter
=IF(A1<"",VLOOKUP(A1,'hidden_sheet'!$A$1:$D$100, 2,0),"")

--
Regards
Frank Kabel
Frankfurt, Germany


Dan Eames wrote:
Hello, I hope you can help.

I have a basic table with many rows but only four
columns.
I have hidden this table from view and created a drop
down
list so that column A is fixed based only on information
that is valid, because I put it there. What I want to
happen then is that columns B, C and D will update their
content directly based upon the data selected in column
A.
Effectively the table will be duplicated but only for
the
row of interest.

Thanks in advance,

Dan

.

Creating a worksheet with values based on a control cell
 

Hi
there's a mximum of 7 NESTED function calls. But why do you need more
IF clauses. I added the IF function only to check if A1 contains a
value at all. the rest is done by VLOOKUP.

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Frank,

Thanks for your help. Is there a maximum number of IF's I
can use becuase I will have to brake down my column A data
if there is.

Thanks,

Dan



-----Original Message-----
Hi
use VLOOKUP for this (if column A contains unique values.). e.g. in
B1 on your second sheet enter
=IF(A1<"",VLOOKUP(A1,'hidden_sheet'!$A$1:$D$100,2 ,0),"")

--
Regards
Frank Kabel
Frankfurt, Germany


Dan Eames wrote:
Hello, I hope you can help.

I have a basic table with many rows but only four columns.
I have hidden this table from view and created a drop down
list so that column A is fixed based only on information
that is valid, because I put it there. What I want to
happen then is that columns B, C and D will update their
content directly based upon the data selected in column A.
Effectively the table will be duplicated but only for the
row of interest.

Thanks in advance,

Dan

.