Question description:
This user has given permission to use the problem statement for this
blog.
Hi, I'm looking to make a list of data dependent on the choices of two cells which have list data inside, E.g if cell a1=x and b1= y then the first line of my data = z but if a1= t and b1 = y then display = g?
Solved by C. A. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
11/03/2018 - 10:42
Hi
Excelchat Expert
11/03/2018 - 10:42
How may i help you
User
11/03/2018 - 10:42
Hello
User
11/03/2018 - 10:45
I have a large amount of data sets which relate to data from suspension, i want to be able to choose the spec of these units and display the data on a graph, there are 2 variables to each unit, eg X and Y and if these are selected then i need to relate that to a specific list of data and for it to = for example Z
Excelchat Expert
11/03/2018 - 10:46
i have written the formula for your requirement
Excelchat Expert
11/03/2018 - 10:46
please have a look
Excelchat Expert
11/03/2018 - 10:47
do you get it?
User
11/03/2018 - 10:47
Yes I was able to do an IF fucntion for 1 Variable but did not know the syntax for 2 varbiables
Excelchat Expert
11/03/2018 - 10:47
does this help you out?
Excelchat Expert
11/03/2018 - 10:47
let me know if you face any issues
Excelchat Expert
11/03/2018 - 10:48
for 2 variables we can use AND
Excelchat Expert
11/03/2018 - 10:48
as i have used
Excelchat Expert
11/03/2018 - 10:48
hope this helps you
Excelchat Expert
11/03/2018 - 10:48
please do give good rating
Excelchat Expert
11/03/2018 - 10:49
it really helps
User
11/03/2018 - 10:50
Can you use names in this formula to relate to a number of rows set of data entirely, or would you have to input this in to the top line of data and drag and drop the formula, locking the variables?
Excelchat Expert
11/03/2018 - 10:50
yes we need to enter in top line and then drag the formula
User
11/03/2018 - 10:51
Ok not a problem, brilliant I will give this a go!
Excelchat Expert
11/03/2018 - 10:52
thanks
User
11/03/2018 - 10:52
thank you!
Excelchat Expert
11/03/2018 - 10:52
welcome
Excelchat Expert
11/03/2018 - 10:52
do give good rating once you end the session
Excelchat Expert
11/03/2018 - 10:52
thanks
Excelchat Expert
11/03/2018 - 10:54
are you still there?
Excelchat Expert
11/03/2018 - 10:55
you can end the session
User
11/03/2018 - 10:57
quick question, when i try to choose the value if true from to be a the first value from my list of relative data, It wont let me? i can only inpute the value manually not reference a cell
Excelchat Expert
11/03/2018 - 10:58
i did not get your question
Excelchat Expert
11/03/2018 - 10:58
in the formula that i have used it is referencing to a cell
User
11/03/2018 - 10:58
No in the value is true you have "Z"
User
11/03/2018 - 10:58
I want the Z for example to be"Sheet1 B72
Excelchat Expert
11/03/2018 - 10:59
yes that you have to manually tell the sheet
User
11/03/2018 - 10:59
ok
Excelchat Expert
11/03/2018 - 10:59
if you have it stored somewhere you can reference it also in the formula
User
11/03/2018 - 10:59
for example this is my formula so far for my worksheet....
Excelchat Expert
11/03/2018 - 11:00
if you dont have many values you can put it manually
Excelchat Expert
11/03/2018 - 11:00
if it is there in excel you can reference it in excel formula
User
11/03/2018 - 11:02
i have many values...
User
11/03/2018 - 11:04
so for example this is my adapted version of the funciton, what I need is for the calculated values Z and G to be actaully referenced from another set of data on another cheet, for example sheet2:C23
Excelchat Expert
11/03/2018 - 11:05
i did not get your question
User
11/03/2018 - 11:05
when I click the cell i want it does not input that cell into the formula, so how do i reference the sheet? and will it automatically then drop down my data sheet e.g. Sheet2:C23
User
11/03/2018 - 11:06
sheet2:c24....
User
11/03/2018 - 11:06
etc etc
Excelchat Expert
11/03/2018 - 11:07
let me look
User
11/03/2018 - 11:07
you can see my formula on the shared sheet?
Excelchat Expert
11/03/2018 - 11:07
where?
User
11/03/2018 - 11:08
in the cell with a ref error
Excelchat Expert
11/03/2018 - 11:08
put some sample data also
User
11/03/2018 - 11:11
so for example when i select T1 and L04H10 I want cell C7 to display Sheet2:A1
Excelchat Expert
11/03/2018 - 11:17
use as i have shown
Excelchat Expert
11/03/2018 - 11:17
use that on youtr excel on oc
Excelchat Expert
11/03/2018 - 11:17
pc
Excelchat Expert
11/03/2018 - 11:17
it will work
User
11/03/2018 - 11:19
will the sheet2!a1 reference change to sheet2a2 and then Sheet2!a3 as ai drag the formula?
Excelchat Expert
11/03/2018 - 11:19
fix that
Excelchat Expert
11/03/2018 - 11:19
using f4
Excelchat Expert
11/03/2018 - 11:19
free the cells
Excelchat Expert
11/03/2018 - 11:19
freeze
User
11/03/2018 - 11:19
yeh i want the sheet2 cells to move, everything else is fixed
Excelchat Expert
11/03/2018 - 11:21
you can freeze if you want to fix else remove
User
11/03/2018 - 11:21
ok, thanks!
User
11/03/2018 - 11:22
will se ehow it goes!
Excelchat Expert
11/03/2018 - 11:22
welcome
Excelchat Expert
11/03/2018 - 11:22
sure
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
