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 each
range every time. Is it possible to just specify the worksheet instead
of a more narrowed down range? Or is there another alternative?

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

Thanks in advance


--
anar_baku
------------------------------------------------------------------------
anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
View this thread: http://www.excelforum.com/showthread...hreadid=483592

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


"anar_baku" wrote:


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 each
range every time. Is it possible to just specify the worksheet instead
of a more narrowed down range? Or is there another alternative?

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

Thanks in advance


--
anar_baku
------------------------------------------------------------------------
anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
View this thread: http://www.excelforum.com/showthread...hreadid=483592