Excel will insert a reference with the correct syntax automatically, sparing you the trouble to check the name and troubleshoot. Instead of typing a sheet name directly in a formula, you can switch to the lookup worksheet and select the range there.
CREATING VLOOKUP IN EXCEL 2016 HOW TO
For more info, please see How to reference another sheet in Excel. If the sheet name contains spaces or non-alphabetical characters, it must be enclosed in single quotation marks, like 'Jan Sales'!$A$2:$B$6.In a similar manner, you can Vlookup data from the Feb and Mar sheets:
Putting the arguments together, we get this formula:ĭrag the formula down the column and you will get this result: