sheet reference

  • Thread starter Thread starter Marco Lorenzo
  • Start date Start date
M

Marco Lorenzo

I have done this before but can't remember how.

How do I reference a sheet tab name in my vlookup?
 
Assuming sheet name is "Easy Dial" then VLOOKUP should look like;
=VLOOKUP(A76,EasyDial!A:B,2,FALSE)


For referencing another workbook use;
=VLOOKUP(A76,'[Copy of index.xls]Sheet1'!$A:$B,2,FALSE)

Best way is to type =VLOOKUP(A1, then click on the sheet and then range you
want...
 
You can put the worksheet name directly in the VLOOKUP:

=VLOOKUP("abc",'Sheet1'!A1:C10,3,FALSE)

You can also take the sheet name from another cell, say E1.

=VLOOKUP("abc",INDIRECT("'"&E1&"'!A1:C10"),3,FALSE)

In this second formula, VLOOKUP will look in the range A1:C10 on whatever
sheet is named in cell E1.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top