PDA

View Full Version : looking for value position in table



amrane
03-27-2011, 07:23 AM
dear forum:help:

To find relative position of given value within table, excel function "match" is not built to give reliable result, so I was pushed to proceed in other way:

separated procedure "basic_routing" is good, but how to use function for easier:

I did demonstration procedure as reference to explain this problem:


1- the range "look_table" is not forwarding information to the function!!!

Plz advice how to proceed.


thx in advance

Bob Phillips
03-27-2011, 08:16 AM
The function is called =value_Position_in_line(A3:A13), it needs to be in a standard module not a worksheet module, but what is wrong with

=MATCH(B2,$A$1:$A$13,1)

amrane
03-27-2011, 09:36 AM
[Dear Mr XLD

A sper defenition match fucntion is never giving code error in case of wrong input data.

ie you can type XLD => match will retur 11!!!!:banghead:

Also PLz let me know what is the problem of "value_Position_in_line" to not accept rage as argument?


Thank you sir,
amrane

Bob Phillips
03-28-2011, 02:10 AM
Sorry amrane, I am struggling to understand your questions.

I don't know what ... XLD => match will retur 11! ... means.

And I do not understand what you mean by ... what is the problem of "value_Position_in_line" to not accept rage as argument?