get cell address

[Svgmassive]

i am trying to get the address of a cell in row 4 in a different workbook that matches 02/12/11.Thanks

 

[MisterBate5]

Have a look a match() function. Will give you the column number if you use $4:$4 as the range. Then put that inside =address().

 

[Aladin Akyurek]

i am trying to get the address of a cell in row 4 in a different workbook that matches 02/12/11.Thanks

Care to elaborate for the information given is just sparse?