A question about Vlookup(absolute cell references )

F

Franz Verga

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
 
E

Elkar

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
 

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

Reposition Cells in a Column based on another 2
absolute reference fill 1
Referencing cells in consecutive rows 2
Formula to Avoid Circular Reference 5
How to create absolute link to cell in another workbook (Excel 2003) 1
Excel 2007 adds a $ sign (absolute reference) when copy/pasting 1
New computer, how do i move outlook 365 ENTIRELY? 0
Can I add a formula or function to Vlookup? 1

Top