Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IV,, VLOOKUP or both??????????????????
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","". |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IV,, VLOOKUP or both??????????????????
I can't really tell what the sheet looks like, but =If(k1=$A$6,"X","") adjust the cells refferences to what you need, because I can't tell |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IV,, VLOOKUP or both??????????????????
Try this formula:
=IF(ISNA(VLOOKUP($K2,B$2:B$8,1,FALSE)),"","X") You'll need to adjust the range information for each column representing Monday thru Friday. Gary "scheduler" wrote: 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","". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |