Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
A B C D
Mon Tue 1) 12:00) Emp#1 12:00) Emp#2 2) 1:00) 1:00) 3) 2:00) Emp#2 2:00) Empl#4 4) 3:00) 3:00) K L M N O P Q M T W T F S Emp#1 X Empl#2 X X Emp#3 Emp#4 X As the employees are placed on the schedule I would like an "x" to appear in their row on the day scheduled. I'm not sure if this is an "IF" formula or a "VLOOKUP" or a combination of both. I have tried this formula FOR CELL L3, w/ no success =IF(VLOOKUP,A1:J50,2,FAULSE)),"X","". |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |