Possible to automate absolute?

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?
 
G

Gord Dibben

Ron

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

Gord Dibben Excel MVP XL2002
 
H

Harald Staff

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

Autonumber field in Excel that behaves the same as Access 0
Drop down list control value in vba 2
Excel - Wich Function should I use? 1
Automation of scanned file storage based on content 0
Referencing cells in consecutive rows 2
vlookup and sorting and references. 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Excel does not accept text format! 0

Top