This is really just a heads up for anyone that, like me, had never browsed through all of the Functions in the function list in Workbook Designer.  I just found out that these 2 functions exist, and they will really help with a lot of the complex formulating in our products.  Wish I had discovered them sooner!

Description: 

Parses a delimited string value and returning the value at the specified Index. The Index is a zero based value where the first value in the delimited list is at zero.

Example: 

Given a prompt Text_String=textA;textB;textC;textD"

Using PARSETEXT(";",text_string,0), you will get the 1st thing in the string (textA). 

Using PARSETEXT(";",text_string,2), you will get the 3rd thing in the string (textC).

VHLOOKUP (combo of VLOOKUP and HLOOKUP)

Description: 

Looks for a value in the search column and a value in the search row of a table, and then returns a value from the intersecting cell of the matched column and row.

Example:

Using VHLOOKUP(value_in_column,value_in_row,range,column#,row#,logical_test,logical_test,logical_test) will cross-reference a value in a column with one in a row to return the value at the intersection of that column and row.  Use the Fx button to find out more about the logical tests, but they work much like a VLOOKUP does.

WARNING:

I have been told by MV that this function reduces speed/performance, so use sparingly.