| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
offset problem list not sequencial
Hi team,
=OFFSET(Alicia!P1,MATCH($C22,Alicia!$P$1:Alicia!$P $500),1) is looking for a value of 7193 on alicia then parse further information along the range to the originator,although 7193 is in the list it is not in a sequencial list and cannot be found. Can anyone point me in the right direction as to how I can find the value, 7193, that is not held in sequencial order ?. many thanks steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Activecell Offset Problem | Excel Worksheet Functions | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Threaded Mode
