LOOKUP function

[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

 

[Guest]

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