Help with MATCH and INDEX

[kmerker]

Hello,

I have a range of cells with random text in them. For example, the
cell range A13 looks like:


1G1 1B2 2G1 8B1

1G9 1G2 4G5 7G3

3G4 1B8 2G1 6B8


I want a function that can tell me the Row and Column of any particular
code. For example if I want to know where 4G5 was, then the function
would return C2 or something that says that its in Row 2 Column C.

Ultimately I want to know the row and column headers for the item but I
can use INDEX to figure that out.

It looks like MATCH might work, but it only lets me operate on a single
row or a single column.


Thanks for any help

 

[Peo Sjoblom]

For the row number

=MAX((A13=E1)*(ROW(A13)))

for the column number

=MAX((A13=E1)*(COLUMN(A13)))

both entered with ctrl + shift & enter