Activate worksheet and vlookup command

[hardroader]

I am attempting to create a comparison type worksheet using the vlookup command.

Vlookup(lookup-value, table-array, col-index, range-lookup) looks like this:
vlookup(a11,G351:ay412,5,false)

For example:
A B C
9 Enter ticker symbol ABT_SAVE ADP_SAVE
10
11 Sector Health Care Technology
12 Industry Med Equip Software

Cell B9 and C9 contains the name of the worksheet where the information resides.

How can I tell the vlookup command to look at ABT_SAVE(vlookup,a11,G351:ay412,5,false)?

Thank you for your assistance.

 

[RickXL]

Hi,

I think you might be looking for something like this:

=VLOOKUP(A11,INDIRECT(B9 &"!G351:AY412"),2,FALSE)

The INDIRECT() function will look in B9 and add that string to the start of the range address for you.