-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ifcommand
-
C
return specific data without spaces
Hi, I have a spreadsheet like the below, that has a long list of clients from sales agents and their current status. ie confirmed pending lost. This spreadsheet is updated constantly with status new deals and amounts. I want a spreadsheet for each Sales Rep that references this master sheet...- CreativeRova
- Thread
- ifcommand multi workbooks vlookup
- Replies: 11
- Forum: Excel Questions
-
Q
How to protect cells with existing data only
I am doing right now the Daily activity report of our team and I need to consolidate and track the time stamp of each activity. My problem right now is once they filled up the activity with timestamp and after entering to a new activity, I would like to protect or not able to edit the previous...- qnecmen
- Thread
- ifcommand macro - auto run vba & excel 2016
- Replies: 0
- Forum: Excel Questions
-
D
IF and VLOOKUPS together
Hi Please can someone help me with the following: I'm developing an excel based calculator that will return different results depending on how an entry compares to a vlookup result. I.e: If the value in cell E13 is less than the vlookup value returned, minus 5%, return "RED" If the value in...- donnarowbo
- Thread
- ifcommand vlookup
- Replies: 8
- Forum: Excel Questions
-
P
Why does IF command and formula break ?
=IF(C10="01", "No Sub Project", IF(C10="03", "Sub Project 1", IF(C10="04", "Sub Project 2", IF(C10="05","Sub Project 3", IF(C10="06", "Sub Project 4", IF(C10="07", "Sub Project 5", IF(C10="08", "Sub Project 6", IF(C10="09", "Sub Project 7", IF(C10="13", "Sub Project 8", IF(C10="14", "Sub Project...- Partypiepom25
- Thread
- arguments commas data validation (list) excel formula ifcommand
- Replies: 1
- Forum: Excel Questions
