| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF/then statement help.....
I am trying to write a If statement but I do not know how to make it answer the way I want it to. I have two worksheets. Sheet1 is where the answer will be. Sheet2 is where I am getting my information. Sheet2: Column: A-----------B Show1 Sunday Show2 Monday Show3 Sunday Show4 Monday Show5 Friday Show6 Tuesday I want to say if col B = Monday then show what is next to the monday ie. Show2 and Show4. I want to be able to run this on more than one cell showing all results in seperate cells. This is something I do not think can be done but I am wondering if maybe someone might have an idea. Thank you -- HxR ------------------------------------------------------------------------ HxR's Profile: http://www.excelforum.com/member.php...o&userid=32147 View this thread: http://www.excelforum.com/showthread...hreadid=519001 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If/Then Statement | Excel Worksheet Functions | |||
| If statement | Excel Discussion (Misc queries) | |||
| if/then statement that results in Yes/No | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| If/Then statement | Excel Discussion (Misc queries) | |||
Threaded Mode
