In Excel, VLOOKUP(key, range, column-in-range, FALSE) looks in the leftmost column of /range/ for /key/, and if it finds it, returns the corresponding value in /column-in-range/, where the key column is number 1.
/range/ should not include the column header row if any. Also you probably should specify it as an absolute value eg $A$2:$B$10, if you intend to repeat your formula in a series of cells.
Anti-nuisance lawsuit warning: The purpose of these notes is to remind me, Zoegond, of stuff or to help me work stuff out. They may contain mistakes.
Quick
- ($a, $b....) = unpack("A2A7...", $packed)
- push( array, list )
