--- title: Excel's Lookup Function - Webinar - U.S. Computer Connection description: If you have been using Excel for some time, you have probably come across situations in which you would like to pull out information from a large data-set without modifying the list or looking across the columns and down the rows to find the information you need. One of the most common ways to quickly […] image: https://blog.uscomputer.com/hubfs/Imported_Blog_Media/WebinarReplay-Oct-17-2022-03-56-09-04-PM.jpg --- [Skip to content](https://blog.uscomputer.com/excels-lookup-function-webinar#main-content) [![USCC_2C_Logo](https://blog.uscomputer.com/hs-fs/hubfs/USCC_2C_Logo.png?width=1078&height=250&name=USCC_2C_Logo.png "USCC_2C_Logo")](http://U.S.%20Computer%20Connection) Search - [Home](https://uscomputer.com) - About Show submenu for About - [Our Team](https://uscomputer.com/our-team) - [Careers](https://uscomputer.com/careers) - [Solutions](https://uscomputer.com/solutions) Show submenu for Solutions - [Cybersecurity](https://uscomputer.com/cybersecurity) - [Data Backup & Disaster Recovery](https://uscomputer.com/data-backup-disaster-recovery) - [Managed IT Services](https://uscomputer.com/managed-it-services) - [IT Projects](https://uscomputer.com/it-projects) - [Cloud Computing](https://uscomputer.com/cloud-computing) - [Blog](https://blog.uscomputer.com) - [Contact Us](https://uscomputer.com/contact) - [Home](https://uscomputer.com) - About Show submenu for About - [Our Team](https://uscomputer.com/our-team) - [Careers](https://uscomputer.com/careers) - [Solutions](https://uscomputer.com/solutions) Show submenu for Solutions - [Cybersecurity](https://uscomputer.com/cybersecurity) - [Data Backup & Disaster Recovery](https://uscomputer.com/data-backup-disaster-recovery) - [Managed IT Services](https://uscomputer.com/managed-it-services) - [IT Projects](https://uscomputer.com/it-projects) - [Cloud Computing](https://uscomputer.com/cloud-computing) - [Blog](https://blog.uscomputer.com) - [Contact Us](https://uscomputer.com/contact) [Client Remote Support](https://uscomputer.com/support/) [Free Strategy Session](https://uscomputer.com/contact/) Call Today! 203.356.0444 # Excel’s Lookup Function – Webinar [Garry Feldman](https://blog.uscomputer.com/author/garry-feldman) Dec 27, 2017 4:14:01 AM [![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](https://www.facebook.com/share.php?u=https%3A%2F%2Fblog.uscomputer.com%2Fexcels-lookup-function-webinar%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on linkedin](https://7528302.fs1.hubspotusercontent-na1.net/hub/7528302/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/linkedin-color.png?width=24&name=linkedin-color.png)](https://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.uscomputer.com%2Fexcels-lookup-function-webinar%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.uscomputer.com%2Fexcels-lookup-function-webinar%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.uscomputer.com%2Fexcels-lookup-function-webinar%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Share on email](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/email-color.png?width=24&name=email-color.png)](mailto:?subject=Check+out+https%3A%2F%2Fblog.uscomputer.com%2Fexcels-lookup-function-webinar%3Futm_medium%3Dsocial%26utm_source%3Demail&body=Check+out+https%3A%2F%2Fblog.uscomputer.com%2Fexcels-lookup-function-webinar%3Futm_medium%3Dsocial%26utm_source%3Demail) [![Click here button for youtube](https://blog.uscomputer.com/hs-fs/hubfs/Imported_Blog_Media/watch-now-button-for-youtube-channels-Oct-17-2022-03-56-09-46-PM.png?width=235&height=94&name=watch-now-button-for-youtube-channels-Oct-17-2022-03-56-09-46-PM.png)](https://www.youtube.com/watch?v=wPJFhFID3Zo) If you have been using Excel for some time, you have probably come across situations in which you would like to pull out information from a large data-set without modifying the list or looking across the columns and down the rows to find the information you need. One of the most common ways to quickly obtain the data you need is to use a Lookup Function. In this webinar, we will demonstrate and explain the following: - How to use VLookup to return an interest rate from a table based upon credit rating - Using VLookup to pull Salary & Hours Worked from a large employee table - How to compare two lists to find items that do not match using VLookup - Use an IF function in conjunction with a Lookup function to extend its power - Use Match to return the position number of an item in an array   [Training](https://blog.uscomputer.com/tag/training), [Employee training](https://blog.uscomputer.com/tag/employee-training), [employee education](https://blog.uscomputer.com/tag/employee-education), [education](https://blog.uscomputer.com/tag/education), [Webinar](https://blog.uscomputer.com/tag/webinar), [Excel](https://blog.uscomputer.com/tag/excel) ## Read On [![](https://blog.uscomputer.com/hs-fs/hubfs/August%202025/Social%20800%20x%20800/PSPro-Cyber%20Insurance%20%26%20IT-Ad-15-800x800.jpg?width=352&name=PSPro-Cyber%20Insurance%20%26%20IT-Ad-15-800x800.jpg)](https://blog.uscomputer.com/it-and-cyber-insurance-why-you-cant-afford-to-ignore-either) ### [IT and Cyber Insurance: Why You Can't Afford to Ignore Either](https://blog.uscomputer.com/it-and-cyber-insurance-why-you-cant-afford-to-ignore-either) Cyberthreats are evolving fast, especially with the rise of AI-powered attacks. That's why a solid... [![](https://blog.uscomputer.com/hs-fs/hubfs/August%202025/Social%20800%20x%20800/PSPro-Cyber%20Insurance%20%26%20IT-Ad-14-800x800.jpg?width=352&name=PSPro-Cyber%20Insurance%20%26%20IT-Ad-14-800x800.jpg)](https://blog.uscomputer.com/cyber-insurance-basics-what-every-business-needs-to-know) ### [Cyber Insurance Basics: What Every Business Needs to Know](https://blog.uscomputer.com/cyber-insurance-basics-what-every-business-needs-to-know) Cyberattacks rarely come with a warning, and when they hit, the damage can be fast and costly. From... [![](https://blog.uscomputer.com/hs-fs/hubfs/July%202025/Social%20800%20x%20800/PSPro-Risky%20vs%20Reliable-Ad-15-800x800.jpg?width=352&name=PSPro-Risky%20vs%20Reliable-Ad-15-800x800.jpg)](https://blog.uscomputer.com/the-role-of-it-service-providers-in-mitigating-it-risks) ### [The Role of IT Service Providers in Mitigating IT Risks](https://blog.uscomputer.com/the-role-of-it-service-providers-in-mitigating-it-risks) In today’s fast-moving business landscape, change is constant and often unpredictable. Markets can... #### Connect with USCC 933 Hope Street Stamford, CT 06907 [Follow us on Facebook](https://www.facebook.com/USComputerConnection) [Follow us on LinkedIn](https://www.linkedin.com/company/us-computer-connection) [Follow us on Facebook](https://www.youtube.com/channel/UCVJhg6c3_PpsUkKyY31areg) [Follow us on Twitter](https://twitter.com/UScomputerConncom) #### Solutions [Managed IT Services for Businesses](https://uscomputer.com/managed-it-services) [Cybersecurity](https://uscomputer.com/cyber-security) [Data Backup & Disaster Recovery](https://uscomputer.com/data-backup-disaster-recovery) [IT Projects](https://uscomputer.com/it-projects) [Cloud Computing](https://uscomputer.com/cloud-computing) Copyright © 2022 USCC. All rights reserved | [Privacy Policy](https://uscomputer.com/wp-content/uploads/2021/09/Online-Privacy-Policy.pdf) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Garry Feldman", "url" : "https://blog.uscomputer.com/author/garry-feldman" }, "dateModified" : "2022-10-17T15:57:49.378Z", "datePublished" : "2017-12-27T09:14:01.000Z", "headline" : "Excel's Lookup Function - Webinar - U.S. Computer Connection", "image" : [ "https://blog.uscomputer.com/hubfs/Imported_Blog_Media/WebinarReplay-Oct-17-2022-03-56-09-04-PM.jpg" ], "mainEntityOfPage" : { "@id" : "https://blog.uscomputer.com/excels-lookup-function-webinar", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.uscomputer.com/hubfs/USCC_2C_Logo.png" }, "name" : "U.S. Computer Connection" } } ```