sheets

K

KisH \(Tihomir\)

Hello,
I have a problem.
I have sheet1,sheet2 and sheet3.
In sheet1 i have 2 columns ( column1 and column2).
Column1 Column2
text1 3
text2 5

1. problem
In sheet2 I need to create drop down box so I can choose if I want text1 or
text2.
But how can I import to drop down box column1 and column2 data from sheet1?
Example. If I choose on sheet2 from drop down box text1, it needs to write
text1 and number 3 (text1 in one column and number 3 in other
column)

2. problem
In sheet 3 I have simple drop down box which reads Column1 from sheet1.
But I need manually to enter some number and it needs to calculate( minus)
Example. If I choose on sheet3 from drop down box text1 and I write number 1
, it needs automaticly to calculate 3-1=2 and correct text1 in sheet1 to 2.

Sorry for bad english and I hope so you can help me.
Thank you.
 
P

Pete_UK

For your first problem you can use VLOOKUP. Assume your drop-down box
in Sheet2 is in A1, then in B1 you can put this formula:

=VLOOKUP(A1,Sheet1!A:B,2,0)

so if you select text1 then 3 will automatically appear.

For the second problem you will need a bit of VBA code to achieve
this, as a formula (in Sheet3) cannot "push" a value to another cell
(on Sheet1).

Hope this helps.

Pete
 
K

KisH \(Tihomir\)

Formula is not working, got some error.
Do you know where is the problem?
And can you please tell me how to solve problem 2.
Thank you!
 
K

KisH \(Tihomir\)

Sorry, it works! :)
Just need to write it this way =VLOOKUP(A1;Sheet1!A:B;2;0).
Now just a Problem2 , anyone?
Thank you!
 
P

Pete_UK

You're welcome - glad you got it working.

I can't help you with the second problem, sorry.

Pete
 
Top