Lookup - Mapping Type

What is Lookup Field?

Lookup Field allows you lookup value from external sources 

for example, Google Sheets, user can lookup values from sheet data based on user entry

Following are external sources

Explanatory Video

Lookup from Google Sheets

How to configure the sheet having headers

How to configure the sheet not having headers

Check lookup

Sample lookup test case having headers

Sample lookup test case not having headers