offset problem list not sequencial

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
add a 0 or false as a new, 3rd argument to the Match function

MATCH($C22,Alicia!$P$1:Alicia!$P$500,0)
 
Hi Duke,

It worked a treat !!!!!!!!!!!!!!! I have been wrestling with this all **^((&
morning !!!

many, many thanks :-)

steve
 
You're very welcome, & thanks for the nice words

steve alcock said:
Hi Duke,

It worked a treat !!!!!!!!!!!!!!! I have been wrestling with this all **^((&
morning !!!

many, many thanks :-)

steve
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VLOOKUP, IF and RIGHT functions together 3
wrong result Paste within same row while filtered condition applie 1
convert yes/no values to text 13
Index and Match 8
Using a cell value in its own calculation 5
OFFSET oddity 7
Combining Average, Offset & Vlookup 4
Dependent drop down dynamic range formula, off sheet. 7

Back
Top