Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
use of MATCH or LOOKUP ? functions
hi, trying to find way to locate text "up" from current position. not sure
which function / how to use. have been looking at: MATCH, LOOKUP.. thanks example have for find last number in a column is: =P54=LOOKUP(9.99999999999999E+307,P$24:P$59) ----- example using for finding next instance "down" from current position is: MATCH(TRUE,OFFSET($AT427:$AT$1231,1,0)="dn",0) array portion: guessing would be able to search from fixed top position of document, down to current position. e.g.: $AT$128:$AT427,-1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH & LOOKUP functions | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
MATCH & IF Functions | Excel Discussion (Misc queries) | |||
The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions |