| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sheet reference
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) "Marco Lorenzo" <Marco wrote in message ... I have done this before but can't remember how. How do I reference a sheet tab name in my vlookup? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
| multiple cell reference from sheet to sheet | Excel Worksheet Functions | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Threaded Mode
