2-way match formula?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: BillS (BillS.12g7lx_at_excelforum-nospam.com)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 10:45:34 -0600

First time on site - please excuse any errors of protocol!

I have a 2 dimensional array of elements, all different.

I would like to find a single formula that will search the array for a
designated element and return the column in which it appears.
Likewise for the row.

So if the array is

2 5 7
6 8 1

The column formula applied to the argument "7" would return 3
and the row formula would return 1.

This is tantamount to asking for the MATCH function, but in 2
dimensions.

Thanks...Bill 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: Populate a Multi-Column ListBox
    ... .Column provides the data for the whole two-dimensional Listbox array by Column - in the same way as .List provides it by Row; in Excel terms Column is List transposed. ... > generates an error "Could not set the column property. ... Thus a Two dimensional Array will create ...
    (microsoft.public.word.vba.userforms)
  • [SUMMARY] Game of Life (#193)
    ... a two dimensional array and a simple ... Board is asking the Cell for it's data and then changing it's state. ... can display either on the screen or by saving a sequence of images to ...
    (comp.lang.ruby)
  • Re: Sun f90 bad optimization for assumed-shape array
    ... >> the array is in contiguous storage. ... > pass any N dimensional array to any M dimensional one. ... be checked or corrected at link time. ...
    (comp.lang.fortran)
  • Re: Two Dimensional Arrays in Ruby?
    ... How does one define and use a two dimensional array in Ruby? ... which gets us our second dimension. ...
    (comp.lang.ruby)
  • Re: awk split() functions return array starts at 1
    ... i.e. an array declared N allowed indexes ... dimensional array, and the index of the diagonal is i-j. ... $1...$n argues even stronger for 1 based in this case (although ... involve taking sub-arrays, and if I take a sub-array from n to ...
    (comp.unix.shell)