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 |
#2
|
|||
|
|||
add a 0 or false as a new, 3rd argument to the Match function
MATCH($C22,Alicia!$P$1:Alicia!$P$500,0) "steve alcock" wrote: 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 |
#3
|
|||
|
|||
Hi Duke,
It worked a treat !!!!!!!!!!!!!!! I have been wrestling with this all **^((& morning !!! many, many thanks :-) steve "Duke Carey" wrote: add a 0 or false as a new, 3rd argument to the Match function MATCH($C22,Alicia!$P$1:Alicia!$P$500,0) "steve alcock" wrote: 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 |
#4
|
|||
|
|||
You're very welcome, & thanks for the nice words
"steve alcock" wrote: Hi Duke, It worked a treat !!!!!!!!!!!!!!! I have been wrestling with this all **^((& morning !!! many, many thanks :-) steve "Duke Carey" wrote: add a 0 or false as a new, 3rd argument to the Match function MATCH($C22,Alicia!$P$1:Alicia!$P$500,0) "steve alcock" wrote: 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 |
Reply |
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) |