CELL function

[Lewiy]

This week I received my latest free chapter of Learn Excel from Mr Excel (Chapter 11). On page 220 there is a solution to a lookup problem which reads:

=VLOOKUP($F28,$F$23:$H$26,CELL("Col",G28)-5,FALSE)

I was curious as to the use of CELL("Col",G28) when surely COL(G28) would work just the same and is more concise.

I must say, I've never found much use for the CELL function (I'm sure it has it's uses ) and it seems odd that some of the features of the function overlap with other functions, namely:
"col", "row", "contents"

When there would appear to be much better ways to obtain the information required.

Does anyone actually use the CELL function on a regular basis or is it just there to look pretty?

 

[pgc01]

Thats a good example for Cell("address",). I've never used this option. I think I'd use address(). For a vertical vector:

=ADDRESS(ROW(INDEX(Rng,MATCH(9,Rng,0))),COLUMN(Rng))

In this case using Cell("Address",) seems, indeed, easier:

=Cell("Address",INDEX(Rng,MATCH(9,Rng,0)))