| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking at multiple cells
Hello,
I would like to reference a cell for data, however if that cell is blenk then look at the next cell, etc. For example: In P1 I would like to reference cell F1, but if E1 is blank then the formula looks at D1, and if D1 is blank I would like to look at C1, if C1 is blank I would like to look at B1, and if B1 is blank I would like to populate P1 with the data from A1. A1 will always have data, but the other cells may be blank. Thanks in advance for the help. Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select multiple adjacent cells of multiple cells without selecting | New Users to Excel | |||
| Select multiple adjacent cells of multiple cells without selecting | Excel Worksheet Functions | |||
| macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| Date and time stamping multiple cells for multiple entries. | Excel Worksheet Functions | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
Threaded Mode
