A question about Vlookup(absolute cell references )

  • Thread starter Thread starter Guest
  • Start date Start date
larfy said:
Except using "$",is there another way to make absolute cell
references?
Click to expand...

AFAIK, no.

The "$" is used just with the aim to have absolute cell references...

--
Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy
 
Not sure what your needs are, but the INDIRECT function may be of use. It
doesn't really create an "absolute" reference, but it can create a reference
that will not change.

=INDIRECT("A1")

This will always point to cell A1, even if new cells are inserted or the
original A1 is deleted.

HTH,
Elkar
 
Back
Top