Many Excel users, are familiar with some Excel Lookup and Reference Functions such as Vlookup, Hlookup, Index, Match and the Transpose function. The question I need to ask is, ” How many have considered the use of the “Indirect Function”, with capabilities to extract information from different workbooks? Here is a video that demonstrates how […]

Read More