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)
 
Back
Top