| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
Hi!
I have a dropdown list, using the validation function, with three responses: Blank Customer Company In the cell below I want it to come up with the matching response depending what is chosen from the dropdown list. So it'll either say: Nothing Customer requirement for... Company requirement for... I used the IF function and it worked for the customer option but I couldn't get it to stay blank when the blank is selected in the dropdown list. HELP! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
Hi,
What is your formula. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kelly" wrote in message ... Hi! I have a dropdown list, using the validation function, with three responses: Blank Customer Company In the cell below I want it to come up with the matching response depending what is chosen from the dropdown list. So it'll either say: Nothing Customer requirement for... Company requirement for... I used the IF function and it worked for the customer option but I couldn't get it to stay blank when the blank is selected in the dropdown list. HELP! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
=IF(H5=S6,S10,S11)
H5 is where the dropdown list is, S6 is Customer S10 is Customer requirement for... S11 is Company requirement for... "Ashish Mathur" wrote: Hi, What is your formula. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kelly" wrote in message ... Hi! I have a dropdown list, using the validation function, with three responses: Blank Customer Company In the cell below I want it to come up with the matching response depending what is chosen from the dropdown list. So it'll either say: Nothing Customer requirement for... Company requirement for... I used the IF function and it worked for the customer option but I couldn't get it to stay blank when the blank is selected in the dropdown list. HELP! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
Hi,
Try this =if(H5="Blank","",IF(H5=S6,S10,S11)) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kelly" wrote in message ... =IF(H5=S6,S10,S11) H5 is where the dropdown list is, S6 is Customer S10 is Customer requirement for... S11 is Company requirement for... "Ashish Mathur" wrote: Hi, What is your formula. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kelly" wrote in message ... Hi! I have a dropdown list, using the validation function, with three responses: Blank Customer Company In the cell below I want it to come up with the matching response depending what is chosen from the dropdown list. So it'll either say: Nothing Customer requirement for... Company requirement for... I used the IF function and it worked for the customer option but I couldn't get it to stay blank when the blank is selected in the dropdown list. HELP! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
That worked! Thanks so much :)
"Ashish Mathur" wrote: Hi, Try this =if(H5="Blank","",IF(H5=S6,S10,S11)) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kelly" wrote in message ... =IF(H5=S6,S10,S11) H5 is where the dropdown list is, S6 is Customer S10 is Customer requirement for... S11 is Company requirement for... "Ashish Mathur" wrote: Hi, What is your formula. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kelly" wrote in message ... Hi! I have a dropdown list, using the validation function, with three responses: Blank Customer Company In the cell below I want it to come up with the matching response depending what is chosen from the dropdown list. So it'll either say: Nothing Customer requirement for... Company requirement for... I used the IF function and it worked for the customer option but I couldn't get it to stay blank when the blank is selected in the dropdown list. HELP! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function
You are welcome. Thank you for the feedback.
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kelly" wrote in message ... That worked! Thanks so much :) "Ashish Mathur" wrote: Hi, Try this =if(H5="Blank","",IF(H5=S6,S10,S11)) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kelly" wrote in message ... =IF(H5=S6,S10,S11) H5 is where the dropdown list is, S6 is Customer S10 is Customer requirement for... S11 is Company requirement for... "Ashish Mathur" wrote: Hi, What is your formula. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kelly" wrote in message ... Hi! I have a dropdown list, using the validation function, with three responses: Blank Customer Company In the cell below I want it to come up with the matching response depending what is chosen from the dropdown list. So it'll either say: Nothing Customer requirement for... Company requirement for... I used the IF function and it worked for the customer option but I couldn't get it to stay blank when the blank is selected in the dropdown list. HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
