Posted to microsoft.public.excel.misc

CLR

Posts: n/a

Reverse Matrix lookup?

Hi All......
I have a small 5x5 matrix on a worksheet. Normally one supplies the Row
and Column Titles of a matrix to return the crossover value. I want to do it
in reverse. I want to supply the crossover value and in return get the Row
and Column Titles from the matrix, (not the Excel cell address).

TIA for any assistance,
Vaya con Dios,
Chuck, CABGx3

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
reverse mapping for LOOKUP table?	Kok Yong Lee	Excel Worksheet Functions	6	March 29th 06 01:57 PM
lookup in MATRIX	Forumchanin	Excel Worksheet Functions	2	December 13th 05 01:29 PM
Need help with reverse phone lookup	steve2003	Excel Worksheet Functions	2	June 21st 05 09:01 PM
Lookup in Matrix	Johannes	Excel Worksheet Functions	5	May 4th 05 10:32 AM
Matrix Query Part II - lookup value	Krista F	Excel Worksheet Functions	1	April 6th 05 02:18 PM

All times are GMT +1. The time now is 06:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us