In the Survey Results worksheet, in the Workshops column, display text associated with answers to Q1 by clicking cell I6 and inserting the VLOOKUP function to do an exact match lookup with the Q1 field as the lookup value, the survey_lookup table as the lookup table, the second col-umn of that table as the return value, and the range_lookup value set to FALSE.

How would you type this VLOOKUP formula

cw 38% O Wed 4:29 PM QE NP_EX_7-3 Q Search Sheet Share AutoSum A9 Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF D = Home Insert Page Layout Formulas Data Review View Table X Cut Calibri (Body) - 11 -A- A = = = Men > Wrap Text Copy Paste Format B I U E A = = = = = = Merge & Center - 16 x fx A B C D E F G H I STEM Mentors General $ . % i conditional Format Cell Insert 3* Delete Format Cles Formatting as Table Clear Styles Sort & Filter J K L M N O P 2 Survey Results Survey Questions Calculated fields Q3 Q5 Return Workshops Speakers Facilities Meals School Prior Conferences 6 Survey001 O will not return 7 Survey002 2 will not return 8 Survey003 a a will return 9 Survey004 3 will return 10 Survey005 b 1 will return 11 Survey006 2 will return 12 Survey007 2 will return 13 Survey008 a bad C 0 will return 14 Survey009 d will not return 15 Survey010 a b b di will not return 16 Survey011 a 1 will return 17 Surveyo12 a bb 2 will return 18 Survey013 a 4 will return 19 Survey014 a a a b C 1 will return 20 Survey015 a bb a 2 will return 21 Survey016 b 5 will return 22 Survey017 b 3 will return 23 Survey018 a b a d a 6 will return 24 Surveyo19 b b b b C1 will not return 25 Survey020 a a b a 4 will return 26 Survey021 b 4 will return 27 Surveyo22 b 2 will return 28 Surveyo23a bb a 1 will return 29 Surveyo24 C 1 will return 30 Survey025 cb b a 4 will return 31 Survey026 b 4 will return 32 Surveyo27 C 0 will not return 33 Surveyo28 b b b a 0 will not return 34 Survey029 2 a b c a 0 will return Documentation Report Survey Results Pivot Tables Lookup Tables Ready Survey Questions + @ J -G O + 120%