find a value in a table

[eirini]

Hi!

I want to lookup a value in a table, and get the row and column of its position.

Is it possibe to use a formula for this?

thank you!!

 

[Somendra Misra]

Hi eirini,

Can you post a sample file with dummy data and expected result.

Regards,

 

[eirini]

hope it's clear..

 

[Somendra Misra]

For getting row use:
=LARGE(IF($D$12=$D$7:$H$9,ROW($D$7:$D$9)-ROW($D$7)+1),1)
For getting column use:
=LARGE(IF($D$12=$D$7:$H$9,COLUMN($D$7:$H$7)-COLUMN($D$7)+1),1)

Both are array formula so must enter with Ctrl+Shift+Enter.
(I assume there will not be any duplicate value in your table)

Regards,

 

[eirini]

fantastic!!
thank you!!

 

[Somendra Misra]

Welcome.

 

[pecoflyer]

A non array solution for the column number =SUMPRODUCT(COLUMN(D7:H9)*(D7:H9="b4"))-COLUMN(D7:H9)+1
The same for the row just replace " column" with " row"