Tag Archives: text dates

Excel Data Shaping Fundamentals VLOOKUP() – What the Function

Biomass Rules Posted on by

A traditional way of shaping data in Excel is by using the VLOOKUP() function.  After identifying the item to look up and the array in which to search for it, a range is identified where the new information can be … Continue reading →

Excel Data Shaping Fundamentals Index/Match – What the Function

Biomass Rules Posted on by

One of the most powerful Excel function tools is the INDEX/MATCH() combination.  It can be set to find specific character strings and deliver the cell contents at the intersection of the row and column string matches. This is the third … Continue reading →