Using VLOOKUP

Joining dataframes using a Python VLOOKUP formula in Mito.

A quick example of using VLOOKUP in Mito.

Instructions for Using VLOOKUP to join dataframes

1. Double click on the first cell in a column where you want to use a VLOOKUP

2. Click on the first cell of the lookup key, in the same dataframe that you are editing.

3. Switch to the dataframe you're looking up in

4. Click on the column header that is the key for your lookup in the new dataframe

5. Holding Shift, click on the column header of the value you want.

6. Enter the index of that new column as the third argument.