How can I automatically get information from one worksheet to another by using idenitifier

[lakers93]

SO basically I have two options for proposing networking/computer equipment for a family. The word part has been already done. now i have to use excel to compare the costs including he subtotal and total of every group.(Computer Equipment , Networking equipment etc). for the second part , i have to choose eiither option and without entering the information in another worksheet, that worksheet should automatically provide the information.the information should be same as the option i chose,which is option 1. So how do i do that? for the time being ignore sheet 2. i copied and pasted that. thanks!

[Max, Singapore]

You can grab the correct column to display using OFFSET
In your file, try this in a new sheet, say in Sheet3
Create a DV to select: Option 1, Option 2 in cell A1
Then place
In C1:
=TRIM(OFFSET(Sheet1!$A$1,ROWS($1:1),MATCH($A$1,Sheet1!$1:$1,0)-1))
In D1:
=IF(OFFSET(Sheet1!$B$1,ROWS($1:1),MATCH($A$1,Sheet1!$1:$1,0)-1)="","",OFFSET(Sheet1!$B$1,ROWS($1:1),MATCH($A$1,Sheet1!$1:$1,0)-1))
Copy C1:D1 down as far as required. Cols C and D will display results according to the option selected in cell A1
----------------
Voila? Wave it, thump the little star at the bottom left of my response