The Match() function returns positions.

Why not post some examples of what you're trying to accomplish?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"spxer" wrote in
message ...

I want to use INDEX() or something similar to fiind a position of a
value. I need to reference the column first. INDEX() looks at rows
first. I really don't want to rearrange my table as it is 20 wide by
1000 long. Is there another solution?


--
spxer
------------------------------------------------------------------------
spxer's Profile:
http://www.excelforum.com/member.php...o&userid=37025
View this thread: http://www.excelforum.com/showthread...hreadid=568648