number1pita
Board Regular
- Joined
- Oct 8, 2013
- Messages
- 51
Hello,
I'm trying to get help on a formula I am trying to create. I want my cell to be if A2 = the date in the column on Sheet3 cells A2-A25 and cells L6-L49 equal the word "Direct" then my cell would fill in the date that is in cells B2-B25 on Sheet 3. If cells L6-L49 equal the word "Accelerated" then my cell would fill in the date that is in the cells I2-I25 on Sheet3. This is the formula I am using, and it isn't working and I can't figure out why. Any help would be greatly appreciated!
=IF(AND(A2=Sheet3!A2:A25, L6:L49="Direct"), Sheet3!B2:B25, Sheet3!I2:I25)</SPAN>
I can't post an image or upload a file, not sure if this helps at all, but the first part is the "New Hires" tab and the second part is "Sheet3"
<TBODY>
</TBODY>
I'm trying to get help on a formula I am trying to create. I want my cell to be if A2 = the date in the column on Sheet3 cells A2-A25 and cells L6-L49 equal the word "Direct" then my cell would fill in the date that is in cells B2-B25 on Sheet 3. If cells L6-L49 equal the word "Accelerated" then my cell would fill in the date that is in the cells I2-I25 on Sheet3. This is the formula I am using, and it isn't working and I can't figure out why. Any help would be greatly appreciated!
=IF(AND(A2=Sheet3!A2:A25, L6:L49="Direct"), Sheet3!B2:B25, Sheet3!I2:I25)</SPAN>
I can't post an image or upload a file, not sure if this helps at all, but the first part is the "New Hires" tab and the second part is "Sheet3"
<TBODY> </TBODY> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<TBODY> </TBODY> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<TBODY>
</TBODY>