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