Thread: Two-way MATCH
View Single Post
  #5   Report Post  
VincentT
 
Posts: n/a
Default


Alan,

Many thanks for your functions and your solutions.

I tried them, it is working after removing the "+ROW (dataRange)-1" and
") or "+COL UMN(dataRange)-1" parts. I have not yet understood why
these ROW and COLUMN parts would be necessary and if I keep them I do
not get the right references.

I appreciated your quick and very helpful reply to my problem! Thanks
again.

Have a good day,

Vincent


--
VincentT
------------------------------------------------------------------------
VincentT's Profile: http://www.excelforum.com/member.php...o&userid=26046
View this thread: http://www.excelforum.com/showthread...hreadid=393930