Introduction

Cross File VLookup allows you to cross correlate two sheets. You’ll find this function under the Functions menu. Select the column you want to match on in the first sheet, and then select the sheet to search and its column. Gigasheet will add a new column to the original file with true (when a match was found) or false (when no match was located), or optionally you can bring in specific fields from the lookup sheet when a match is found.

How to get there

Login to Gigasheet > open a Sheet > select Insert> select Cross File Vlookup

Once Cross File Vlookup is selected, a pop-up to select the columns will appear: 

Select Column: Select column allows you to select the column on the current sheet to conduct the Vlookup.

Select File: Select lookup file allows you to browse your Gigasheet library for the file to to conduct the Vlookup.

Select Lookup Column: Once you have the file selected, select the second column to conduct the Vlookup against.

Near Match: When toggled on, white space, case, and punctuation will be ignored.

New Column(s) Content > True/False: Gigasheet will insert TRUE in a new column when the value is found between the columns.

New Column(s) Content > Value: Gigasheet will insert a new column and populate with cell values into the existing sheet when a match occurs.