Calc # 9 - VLOOKUP to the left with CHOOSE - Part 4 - OpenOffice 4.0
Even without INDEX and MATCH, you can search to the left of the search criterion. The CHOOSE function allows you to define the matrix as needed. This also makes the original VLOOKUP function possible to the left.
Calc Playlist: • Playlist