Creating a worksheet with values based on a control cell

D

Dan Eames

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
 
F

Frank Kabel

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),"")
 
G

Guest

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
 
F

Frank Kabel

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.
 
Top