Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.