Possible to automate absolute?

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have used absolute values ($A$1) in a work sheet using
Lookup tables but find entering the '$'_'$'_ tedious
after having selecting the lookup cell reference.

Is there a way to automate absolute values by selecting a
number of cells?
 
Ron

"Automate" usually means VBA code. Would you care to have some posted?

Gord Dibben Excel MVP XL2002
 
If you have reasonable few lists in the workbook, then the imo best way is to give them
names. Select their cells (say A2:H160 in Sheet2) and name it "PriceList" with menu Insert
Names > Define. Suddenly something like
Click to expand...
=VLOOKUP(A2,Sheet2!$A$2:$H$160,4)
becomes as easy as
=VLOOKUP(A2,PriceList,4)
 

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

absolute reference fill 1
Absolute References and worksheets 0
Lookup returning wrong results 0
function to take info fromseveral worksheets and put into a master 1
Conditional formatting on a dynamic range - workaround 1
Subtotalling taking long time to complete 4
Variable Cell Reference 2
Using Value of a Cell in the Range Reference in VLOOKUP 1

Back
Top