| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capturing data using a formula
I am trying to capture text in a range of cells using a formula only if the
text in another cell matches the criteria. Here is what I have come up with: =MB41!B9&":"&B117(IF(MB41!$B$9:$B$120=B5)) Could you tell me what I have wrong? -- Thank you, JR |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating data makes formula wrong | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
