| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Construct cell reference for use in formula
I have Dates in column A with an associated text in column B.
How do I evaluate the text in an If function for a given Date when I don't know which row I need? If I knew 1/1/05 was in row 10, I use IF(B10="B" but how do I construct this refernce when I don't know that I want row 10? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell reference in a formula is called | Excel Discussion (Misc queries) | |||
| Apply a simple formula to multiple rows? | New Users to Excel | |||
| Is it Possible in a formula to have a formula for cell reference? | Excel Worksheet Functions | |||
| Cell Reference Math | Excel Worksheet Functions | |||
| Look Up and Cell Reference - Formula Help Needed | Excel Worksheet Functions | |||
Threaded Mode
