Change dependent cell values every time the value of a drop down cell value changes for the same cell

[vij]

I require help in achieving the following:

I have a drop down list in column A and values corresponding to Column A in B:I columns on a separate sheet.
In a new sheet every time the value in Column A changes I want the values in Column B:L to also change to the new values of Column A

[TABLE="class: grid, width: 690, align: center"]
<tbody>[TR]
[TD]
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]KTX No
[/TD]
[TD]NVR Computer Name:
[/TD]
[TD]Host Name:
[/TD]
[TD]NVR IP Address:
[/TD]
[TD]Gateway Address:
[/TD]
[TD]Network Mask:
[/TD]
[TD]MAC ADDRESS:
[/TD]
[TD]UNLOCK PASSWORD
[/TD]
[TD]IP Address[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]NOI_01_KTX_04

[/TD]
[TD]Sec 2
[/TD]
[TD]Vijay
[/TD]
[TD]11:111:1:10
[/TD]
[TD]AA:11:SS
[/TD]
[TD]255.255.2552.0

[/TD]
[TD]00:06:68:02:19:45

[/TD]
[TD]E0EB5269

[/TD]
[TD]10.40.100.24[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]NO3_01_KTX_06

[/TD]
[TD]Sec 3
[/TD]
[TD]Rajiv
[/TD]
[TD]22:221:1:10
[/TD]
[TD]AA:55:PP
[/TD]
[TD]255.255.2552.0

[/TD]
[TD]00:06:68:02:19:42

[/TD]
[TD]2D176449

[/TD]
[/TR]
</tbody>[/TABLE]

Thanks,
Vijay

 

[Robert Mika]

If your data are in Sheet 1 starts from A1(the first heading):
B2 down and accross:


If you have headings:

Excel 07/10
=IFERROR(INDEX(Sheet1!$A$2:$N$1000,MATCH($A2,Sheet1!$A$2:$A$1000,0),MATCH(B$1,Sheet1!$A$1:$N$1,0)),"")

Excel 03/07/10
=IF(ISNA(INDEX(Sheet1!$A$2:$N$1000,MATCH($A2,Sheet1!$A$2:$A$1000,0),MATCH(B$1,Sheet1!$A$1:$N$1,0))),"",INDEX(Sheet1!$A$2:$N$1000,MATCH($A2,Sheet1!$A$2:$A$1000,0),MATCH(B$1,Sheet1!$A$1:$N$1,0)))

If you do not have headings:

Excel 07/10
=IFERROR(VLOOKUP($A2,Sheet1!$A$2:$N$1000,COLUMN(B$2),0),"")

Excel 03/07/10

=IF(ISNA(VLOOKUP($A2,Sheet1!$A$2:$N$1000,COLUMN(B$2),0)),"",VLOOKUP($A2,Sheet1!$A$2:$N$1000,COLUMN(B$2),0))

 

[vij]

Hi Robert,
Thanks for the quick reply.
Just to clarify, the data is in sheet1 with the headings from
A1 to I1
And the data is fro A2:I30.
The drop down list is in sheet2 cell A2 and the corresponding values should be updated in cell B2 to I2 every time the value in A2 changes.
Hope this is more specific.
Thanks,
Vijay

 

[vij]

I am using Office 2010.

 

[Robert Mika]

Hi Robert,
Thanks for the quick reply.
Just to clarify, the data is in sheet1 with the headings from
A1 to I1
And the data is fro A2:I30.
The drop down list is in sheet2 cell A2 and the corresponding values should be updated in cell B2 to I2 every time the value in A2 changes.
Hope this is more specific.
Thanks,
Vijay

This shoudl work then:
=IFERROR(INDEX(Sheet1!$A$2:$I$30,MATCH($A2,Sheet1!$A$2:$A$30,0),MATCH(B$1,Sheet1!$A$1:$I$1,0)),"")

Drag down and accross.

 

[vij]

Thanks Robert..

 

[Robert Mika]

You are welcome.