Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use cell fron different sheet in IF statement
Two of us who know just enough to be dangerous tried different variations for
over 2 hours last night. We need to be able to pull data from sheet 40, cell C24 and use it in an IF statement. We could pull the data from sheet 40 by itself and insert it into a cell on our current sheet, then in a different cell, take that and use the IF, but we were unable to do it in one step. Here's basically what we tried, I am hoping this is possible and we just couldn't get the hang of the syntax: =IF('40'!C24=X,1,0) Any help will be greatly appreciated, TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use cell fron different sheet in IF statement
Is the name of the sheet actually 40? That is what you are showing with the
'40'! if it is not, change it. Also put your 'X' in quotes "x". -- -John Please rate when your question is answered to help us and others know what is helpful. "Cyberbiker" wrote: Two of us who know just enough to be dangerous tried different variations for over 2 hours last night. We need to be able to pull data from sheet 40, cell C24 and use it in an IF statement. We could pull the data from sheet 40 by itself and insert it into a cell on our current sheet, then in a different cell, take that and use the IF, but we were unable to do it in one step. Here's basically what we tried, I am hoping this is possible and we just couldn't get the hang of the syntax: =IF('40'!C24=X,1,0) Any help will be greatly appreciated, TIA |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use cell fron different sheet in IF statement
=IF('40'!C24="X",1,0) with quotes on the X
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Cyberbiker" wrote in message ... Two of us who know just enough to be dangerous tried different variations for over 2 hours last night. We need to be able to pull data from sheet 40, cell C24 and use it in an IF statement. We could pull the data from sheet 40 by itself and insert it into a cell on our current sheet, then in a different cell, take that and use the IF, but we were unable to do it in one step. Here's basically what we tried, I am hoping this is possible and we just couldn't get the hang of the syntax: =IF('40'!C24=X,1,0) Any help will be greatly appreciated, TIA |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use cell fron different sheet in IF statement
It is actually just 40. I think that we tried the quotes on the "X", but
I'll try again. He has the file on his computer, but I don't have it here on mine. Thanks for your reply. Dean "John Bundy" wrote: Is the name of the sheet actually 40? That is what you are showing with the '40'! if it is not, change it. Also put your 'X' in quotes "x". -- -John Please rate when your question is answered to help us and others know what is helpful. "Cyberbiker" wrote: Two of us who know just enough to be dangerous tried different variations for over 2 hours last night. We need to be able to pull data from sheet 40, cell C24 and use it in an IF statement. We could pull the data from sheet 40 by itself and insert it into a cell on our current sheet, then in a different cell, take that and use the IF, but we were unable to do it in one step. Here's basically what we tried, I am hoping this is possible and we just couldn't get the hang of the syntax: =IF('40'!C24=X,1,0) Any help will be greatly appreciated, TIA |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use cell fron different sheet in IF statement
Thanks to you both!! I just set up a fast & dirty workbook & that was it, we
didn't have the quotes. Too late last night - couple of legal beverages... just couldn't make it work. Thanks again, Dean "Bernard Liengme" wrote: =IF('40'!C24="X",1,0) with quotes on the X best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Cyberbiker" wrote in message ... Two of us who know just enough to be dangerous tried different variations for over 2 hours last night. We need to be able to pull data from sheet 40, cell C24 and use it in an IF statement. We could pull the data from sheet 40 by itself and insert it into a cell on our current sheet, then in a different cell, take that and use the IF, but we were unable to do it in one step. Here's basically what we tried, I am hoping this is possible and we just couldn't get the hang of the syntax: =IF('40'!C24=X,1,0) Any help will be greatly appreciated, TIA |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use cell fron different sheet in IF statement
If you think the problem is with the file name do this;
1) Type =IF( 2) Point to cell C24 on the other sheet The Formula bar will read =IF(sheet_name!C24 3) Compete the formula by typing the rest best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Cyberbiker" wrote in message ... It is actually just 40. I think that we tried the quotes on the "X", but I'll try again. He has the file on his computer, but I don't have it here on mine. Thanks for your reply. Dean "John Bundy" wrote: Is the name of the sheet actually 40? That is what you are showing with the '40'! if it is not, change it. Also put your 'X' in quotes "x". -- -John Please rate when your question is answered to help us and others know what is helpful. "Cyberbiker" wrote: Two of us who know just enough to be dangerous tried different variations for over 2 hours last night. We need to be able to pull data from sheet 40, cell C24 and use it in an IF statement. We could pull the data from sheet 40 by itself and insert it into a cell on our current sheet, then in a different cell, take that and use the IF, but we were unable to do it in one step. Here's basically what we tried, I am hoping this is possible and we just couldn't get the hang of the syntax: =IF('40'!C24=X,1,0) Any help will be greatly appreciated, TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Financial projections - Income statement, bal sheet and cash flows | Excel Discussion (Misc queries) | |||
Copy variable ranges fron difernte shets | Excel Worksheet Functions | |||
dates and if statement work on one sheet, not on another | Excel Worksheet Functions | |||
Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc. | Excel Worksheet Functions | |||
Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions |