sheet reference

M

Marco Lorenzo

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

How do I reference a sheet tab name in my vlookup?
 
S

Sheeloo

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...
 
C

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using strings in vlookup function calls 5
VLOOKUP: Referencing worksheets whose names contain commas 7
Match and delete rows on two different sheets from reference numbers 4
update vlookup formula sheet reference for multiple sheets 5
Dependent drop down dynamic range formula, off sheet. 7
Need VLOOKUP to Work Two Ways 0
Excel Excel Vlookup formula based on cell data 7
Using a cell reference of a sheet in Vlookup 3

Top