Help with MATCH and INDEX

K

kmerker

Hello,

I have a range of cells with random text in them. For example, the
cell range A1:D3 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
 
P

Peo Sjoblom

For the row number

=MAX((A1:D3=E1)*(ROW(A1:D3)))

for the column number

=MAX((A1:D3=E1)*(COLUMN(A1:D3)))

both entered with ctrl + shift & enter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top