How to Use the Lookup Function in Excel

PDF download Download Article
PDF download Download Article

Whenever you keep track of data in spreadsheets, there'll come a time when you want to find information without having to scroll through endless columns or rows. We'll show you how to use Microsoft Excel's LOOKUP function to find a value from one row or column in a different row or column. If you're looking to do a reverse Vlookup, check out How to Do a Reverse Vlookup in Google Sheets.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/62\/Use-the-Lookup-Function-in-Excel-Step-1-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/62\/Use-the-Lookup-Function-in-Excel-Step-1-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    In this example, one column has numbers and the other has random words.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a5\/Use-the-Lookup-Function-in-Excel-Step-2-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/a\/a5\/Use-the-Lookup-Function-in-Excel-Step-2-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9f\/Use-the-Lookup-Function-in-Excel-Step-3-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/9f\/Use-the-Lookup-Function-in-Excel-Step-3-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Use-the-Lookup-Function-in-Excel-Step-4-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/d\/d3\/Use-the-Lookup-Function-in-Excel-Step-4-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/86\/Use-the-Lookup-Function-in-Excel-Step-5-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/8\/86\/Use-the-Lookup-Function-in-Excel-Step-5-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2d\/Use-the-Lookup-Function-in-Excel-Step-6-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-6-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/2d\/Use-the-Lookup-Function-in-Excel-Step-6-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    Select the first column of your list and press enter and click OK when the data validation window appears, now you should see a box with an arrow on, if you click on it your list should drop down.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3a\/Use-the-Lookup-Function-in-Excel-Step-7-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-7-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/3a\/Use-the-Lookup-Function-in-Excel-Step-7-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Use-the-Lookup-Function-in-Excel-Step-8-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-8-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/6b\/Use-the-Lookup-Function-in-Excel-Step-8-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6d\/Use-the-Lookup-Function-in-Excel-Step-9-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-9-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/6d\/Use-the-Lookup-Function-in-Excel-Step-9-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/29\/Use-the-Lookup-Function-in-Excel-Step-10-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-10-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/29\/Use-the-Lookup-Function-in-Excel-Step-10-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/60\/Use-the-Lookup-Function-in-Excel-Step-11-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-11-Version-3.jpg","bigUrl":"\/images\/thumb\/6\/60\/Use-the-Lookup-Function-in-Excel-Step-11-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Use-the-Lookup-Function-in-Excel-Step-12-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-12-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/3c\/Use-the-Lookup-Function-in-Excel-Step-12-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b5\/Use-the-Lookup-Function-in-Excel-Step-13-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-13-Version-3.jpg","bigUrl":"\/images\/thumb\/b\/b5\/Use-the-Lookup-Function-in-Excel-Step-13-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
  14. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/31\/Use-the-Lookup-Function-in-Excel-Step-14-Version-3.jpg\/v4-460px-Use-the-Lookup-Function-in-Excel-Step-14-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/31\/Use-the-Lookup-Function-in-Excel-Step-14-Version-3.jpg\/aid198627-v4-728px-Use-the-Lookup-Function-in-Excel-Step-14-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/3.0\/\">Creative Commons<\/a><br>\n<\/p><p><br \/>\n<\/p><\/div>"}
    15. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Show More Tips
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      How to Create a Graph in Excel
      How to
      Reduce Size of Excel Files
      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Link Sheets in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Password Protect a Microsoft Excel Spreadsheet
      Advertisement

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 319,376 times.

      Is this article up to date?

      Advertisement