i need to find cell reference based on matching data

**moin** · 12-12-2012, 07:11 AM

hello all , can anyone help, please
i want to search OK7V0T in all cells and return the cell reference beside matching data row

serial 1 serial 2 serial 3

box-4 OK4KCU OK4KI0 OK4LLS
box-4 OK60ZD OK62AP OK62QU
box-4 OK6TA5 OK6TBP OK6TFW
box-4 OK7V0T OK7WC4 OK7WL1
box-4 FOC OK4827 OK483E
box-4 OKIA9L OKIAEC OKIAI9

OK7V0T D6 how do write cell ref D6 by applying excel formula
OK6TBP E5
OK4LLS

**dilipandey** · 12-23-2012, 02:07 AM

Hi Moin,

Try using below formula:-

Formula:

Please Login or Register  to view this content.

Enter formula using key combination ctrl shift enter.

See attached:-

Regards,
DILIPandey
<click on below * if this helps>

**bebo021999** · 12-23-2012, 04:00 AM

@dili,
no need to use array formula;

Please Login or Register  to view this content.

Just enter

**Ghozi Alkatiri** · 12-23-2012, 04:27 AM

use formula array

{=ADDRESS(MIN(IF($C$3:$F$8=I1;ROW($C$3:$F$8)));MIN(IF($C$3:$F$8=I1;COLUMN($C$3:$F$8)));4) }

**dilipandey** · 12-23-2012, 04:31 AM

Great..

I used this earlier with indirect function to fetch the content of the cell.. but thought let me try different idea this time

Regards,
DILIPandey
<click on below * if this helps>

i need to find cell reference based on matching data

LinkBack

Thread Tools

Rate This Thread

Display

i need to find cell reference based on matching data

Re: i need to find cell reference based on matching data

Re: i need to find cell reference based on matching data

Re: i need to find cell reference based on matching data

Re: i need to find cell reference based on matching data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions