Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This seems like it should be relatively straightforward but I can't
figure out a solution. Cell AO5 contains 12/1/2007. E5:P5 contains: 1/1//2007 2/1/2007 3/1/2007 4/1/2007 5/1/2007 6/1/2007 7/1/2007 8/1/2007 9/1/2007 10/1/2007 11/1/2007 12/1/2007. I want to return the cell address three rows below row 5, which corresponds to the value in AO5. In this case, I would want cell address P8 returned, since P5 contains the value 12/1/2007. Any ideas as to how to approach this problem? Thanks. Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return Formula results to specific row of matched criteria | Excel Worksheet Functions | |||
Return Matched Numeric Labels across Single Row | Excel Worksheet Functions | |||
Return Matched Numeric Values across Rows | Excel Worksheet Functions | |||
Return Title to matched column | New Users to Excel | |||
How to compare 2 lists and return un-matched? | Excel Worksheet Functions |