| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Nested Formula
Good day, I am trying to accomplish a formula that requires If statements and/or vlookup's but I am not sure of the syntax. I have attached my workbook for easier clarification. Essentially I have two sheets, one for May and one for June. On June's sheet I want to lookup the Account # and the Paycode and the Amount and if all three validations are in May's data(True) I would like to place a Y in cell E2. I am wondering if this is actually possible without using VBA. Any help would be great. +-------------------------------------------------------------------+ |Filename: Nested.zip | |Download: http://www.excelforum.com/attachment.php?postid=3590 | +-------------------------------------------------------------------+ -- TheLeafs ------------------------------------------------------------------------ TheLeafs's Profile: http://www.excelforum.com/member.php...o&userid=10131 View this thread: http://www.excelforum.com/showthread...hreadid=386114 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| looking for a formula | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Linear Mode
