Hi everyone! I'm trying to search a cell against a range to see if a value from the range is present and if so, return that value:
Example:
Range
Basically what I want to do in the second column is have an equation that searches the first column to see if a value from the range is present and if so, return that value.
Any help is greatly appreciated!
Example:
Cells To Search For Value | Equation to search cells agains Range |
This is my new car for the year | new car |
Did she buy the house for her family | buy the house |
What time is the doctors appointment in the city | doctors appointment |
Range
doctors appointment |
buy the house |
new car |
Basically what I want to do in the second column is have an equation that searches the first column to see if a value from the range is present and if so, return that value.
Any help is greatly appreciated!