user2900455
Reputation: 21
Return value of a Cell as value if true or false of a function
I would like to get a value of a particular cell as value if true or value if false option using functions in excel. the exact problem i have is as follow
in column A I have the name list of the students and in column B I have their birthplace. Now I would like to find out the students from a particular city.
The best solution i could find was to use:
=IF(COUNTIF(A1,"*California*"),"Yes","No")
But instead of "Yes", I want the students name from California of corresponding row.
Upvotes: 2
Views: 31917
Answers (1)
Related Questions
- Excel formula - IF true, return a text and cell value
- Excel formula if returns false
- How to return a Boolean value from a Function?
- Return a Boolean value from one function to another function - VBA
- If Formula with formulas in Value if true/false
- MS Excel, How to make the IF formula spit back the value of the cell if condition is FALSE?
- Formula to Check Two Cells and Return a Value
- Returning a Boolean Value in VBA
- Excel: Using the return value of logical test as return value of IF function
- Returning cell as a variable from function in Excel