The basic LOOKUP function in Excel comes in two forms ... [if_not_found], [match_mode], [search_mode]). Here's what each ...