| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
look any text in a range
I have 2 ranges: One range with empty and filled cells and another with
dates. I´d like that Excel give the date from the second range that correspond to the first filled cell in the first range. Is there any formula that solves my problem? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
look any text in a range
Try the combination of INDEX-MATCH or VLOOKUP.
-- John Mansfield cellmatrix.net "fsdias" wrote: I have 2 ranges: One range with empty and filled cells and another with dates. I´d like that Excel give the date from the second range that correspond to the first filled cell in the first range. Is there any formula that solves my problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum A Range only if no text is present in the range | Excel Worksheet Functions | |||
| Search range for text not in another range | Excel Discussion (Misc queries) | |||
| conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
Linear Mode
