Livesheets VLookup Equivalent

This Livesheet is the full equivalent of VLookup.

Unfortunately it doesn’t work as a web form, but you can Use it by clicking on Use This, and then make use of it within your own livesheets.

To use it, enter the lookup value in the first box, the list of values you want to match it against in the second box (in ascending order), and the corresponding list of values you want to pick a result from in the third box.

It looks for the first answer that is higher than the lookup value and returns the corresponding return value. If the lookup value is higher than or equal to all the values in the second box, it returns the (n+1)th item in the return list if it exists. This means the return list can be one longer than the lookup list.

Comments are closed.