How To: Use VLOOKUP to verify a record is in an Excel table

Use VLOOKUP to verify a record is in an Excel table

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 558th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if a record is in a table using VLOOKUP. See how to do this for a 2 column (field) table and a 4 column (field) table. See also how to add a concatenated column and concatenate lookup_value in VLOOKUP function.

Get the latest from WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard

Be Smarter Than Your Smartphone

Get Gadget Hacks' newsletter

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest