The VLOOKUP function in Excel is designed to search for a ‘Lookup Value’ in the first column of the specified Table and return the corresponding Value against the first matching Value. But what if there are two tables, one of which has the possible matching value? A single VLOOKUP function can’t lookup into two different…
In Excel, there can be two types of hidden Worksheets. One is ‘hidden‘ and other one is ‘very hidden‘. The normal ‘hidden’ mode is known to most of the Excel users. But the ‘very hidden’ mode is less known and Advanced Excel users make use of this feature. Very Hidden Worksheets are often used to…
Mr.Excel.com Bill Jelen aka Mr. Excel is a 17 times Microsoft Excel MVP award winner. His website mrexcel.com answers over 30,000 Excel questions a year. Bill Jelen also manages a YouTube channel in the same name and has done more 2,000 videos on Excel. Whenever Microsoft releases a new feature in Excel, you can expect…