LOOKUP function

A

anar_baku

Hi Guys,

When using the VLOOKUP function, you have to specify an array. However
my spreadsheet has many sheets and it's a bit tedious to specify eac
range every time. Is it possible to just specify the worksheet instea
of a more narrowed down range? Or is there another alternative?

Please help, or I'll have to sit there for ages :(

Thanks in advanc
 
D

Duke Carey

Give each of your lookup ranges a simple name -

"Look1", "Look2", etc

Then you can either type in the simple name or use the F3 key and choose
from the list
 
Top