MS Excel - H & V Lookups Question Title * 1. What is your name? (First, Last) Question Title * 2. What is your location? Winnipeg, MB Regina, SK Saskatoon, SK Itasca, IL Kent, WA Vaughan, ON Other Question Title * 3. What is your role/job title/department? Question Title * 4. Which is the correct formula for Vlookup? =vlookup(lookup_value, table_array, col_index_num, [range_lookup]) vlookup(lookup_value, table_array, col_index_num, [range_lookup]) =vlookup(lookup, table_array, col_index_num, [range]) None of the above Question Title * 5. What is the purpose of the using Vlookup? When you need to find things is a table or a range by row When finding the sum in a range Both A&B None of the above Question Title * 6. Suppose cells A1:A4 contain these value: 10, 20, 30, 40. What does the formula =vlookup(15,A1:A4,1,True) return? 20 10 #N/A 0 Question Title * 7. By default, XLOOKUP defaults to which kind of matching method? Exact match with #NA if item not found Approximate match with next smallest if item not found Approximate match with next largest if item not found None of the above Question Title * 8. You have a scenario where you need to write a VLOOKUP-style approximate match, but you need to get the next LARGEST value if a match isn't found, not the next smallest value that VLOOKUP would produce. Which XLOOKUP function would make that happen? Formula A: =XLOOKUP(B17,Items[Description],Items[Description],"Not Found",1) Formula B: =XLOOKUP(I15,Items[Description],Items[Description],"Not Found!") Formula C: =XLOOKUP(B17,Items[Description],Items[Description],"Not Found",-1) Question Title * 9. How would you rate the relevance of this material to your day-to-day job? Extremely valuable Somewhat valuable Not valuable at all Question Title * 10. Did you learn anything about the position/topic that you didn’t know prior to this? Question Title * 11. How would you rate the relevance of this material to your day-to-day job? A great deal A moderate amount None at all Question Title * 12. What kind of content would you like to see in the future to help improve your day-to-day work life? Check all that apply: Current updates in the industry Step-by-step guides to using specific software/programs Shortcuts in the programs I currently use Other Question Title * 13. If you selected other material that you would like to see in the future, please be specific: Question Title * 14. If you selected other material that you would like to see in the future, please be specific: Question Title * 15. Was there anything unclear in the material that you would like your manager or the Frontier-U team to expand on? Done