A question about Vlookup(absolute cell references )

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Except using "$",is there another way to make absolute cell references?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to Avoid Circular Reference 5
Excel How to code in excel vba 2007 using absolute refernce for cells 1
absolute reference fill 1
Can't Explain N/A in Vlookup 2
VLOOKUP 2
range label works in VLOOKUP except if refenced in another cell 3
Excel 2007 adds a $ sign (absolute reference) when copy/pasting 1
Change a cell reference from relative to absolute 2

Back
Top