| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for value in a range
Is there a function which can search for a value in a range and return a
"true" or "false" if it finds it. eg. =if(A2=B2:B30,12,0) So if the value in cell A2 is found in the range B2:B30 then 12, if not then 0. Obviously this particular formula doesn't work otherwise I wouldn't be asking. How can I change it so it does what I'm try to make it do. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search within a range of cells? | Excel Discussion (Misc queries) | |||
| Search range for text not in another range | Excel Discussion (Misc queries) | |||
| how do you search a range of cells... | Excel Discussion (Misc queries) | |||
| How do I search a data range for a particular value then collate . | Excel Discussion (Misc queries) | |||
| How do I get excel search through a range of numbers e.g. 1.99 - . | Excel Worksheet Functions | |||
Threaded Mode
