How to use Address to find the location of a specified cell in Excel2003

How to use address to find the location of a specified cell in Excel2003

① We open Excl2003, create a new worksheet that contains information about regions, cities, lottery lists, and so on. See Su Hao this employee lucky jackpot, in order to let everybody see clearly, I already in the original table red display, we want to know its cell position through the function, in F2 cell enter: =address (1+match (e2,c2:c10,0), COLUMN (C1)).

② return Press, get the result is $c$8, meaning that the winning person in C8 cell.

③ change the name of the winning person, the corresponding results also change, for example, Zheng June winning, is C6 cell.

Formula meaning

Addresses: Gets the address of a worksheet cell, given the number of rows and columns specified.

The match function returns the Su Hao position in column C 8,column returns the number of columns C,address function returns the address C8 according to line number 8, column number C.

Word Tutorial

Excel Tutorials

PowerPoint Tutorials