Using VLOOKUP
Joining dataframes using a Python VLOOKUP formula in Mito.
Instructions for Using VLOOKUP to join dataframes
Double click on the first cell in a column where you want to use a VLOOKUP
Click on the first cell of the lookup key, in the same dataframe that you are editing.
Switch to the dataframe you're looking up in
Click on the column header that is the key for your lookup in the new dataframe
Holding
Shift
, click on the column header of the value you want.Enter the index of that new column as the third argument.
Last updated