The vlookup function in excel is one of the most powerful tools to a voice engineer, which at times can seem more like being a database administrator. The logic here is simple: find the user id from the table on the left in the user id column on the table in the right. When you find it, return the value in the row x number of rows away.

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

lookup_value = userid

table_array = the entire table on the right. the leftmost column must contain the lookup value

col_index_num = how many rows to the right to grab the value to return

range_lookup = false always!


Well oh well, I guess it’s been a while since I posted anything. I’ve been so busy lately, mostly working in large bat files or manipulating call manager databases.
Something that ticked me off was how you can’t put windows side by side because they are nested inside Excel. The following code makes all Excel files open in a new window!

*Note this is for .xls files, for .xlsx change the (Excel.Sheet.8 to Excel.Sheet.12), For .csv files, it’s Excel.CSV


@=””C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE” /e “%1″”