How to find the Match

[bhos123]

I have a value say "abcd". I want to use a formula to find a cell with this value in entire workbook. basically I want a formula for control+ F

 

[LauraScott]

I have a value say "abcd". I want to use a formula to find a cell with this value in entire workbook. basically I want a formula for control+ F

Read the following: http://www.mrexcel.com/forum/excel-...-entire-workbook-duplicates-cell-entered.html

 

[Anand Sharma]

Hi,

This is may be what you want

=ADDRESS(SUMPRODUCT((A1:D5="abcd")*ROW(A1:D5)),SUMPRODUCT((A1:D5="abcd")*COLUMN(A1:D5)),4)

change range according to your data