Tips & Tutorial

Simple VLookUp Formula for Excel

By admin
VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so-called ‘table array’), in order to return a value from a different column in the same row.  In other words, the VLOOKUP function is a premade function in Excel, which allows searches across columns. Here is the formula of a simple VLOOKUP for two columns.

=VLOOKUP(C2,C5:D17,2,TRUE)

Related posts:

  1. How to extract URLs from hyperlinked text in Microsoft Excel
  2. Excel Formula: Check If First Letter in the Cell is Capital or not.
  3. Excel Formula: Change Case of First Letter Only
  4. Excel Formula: How To Find If Cell Begins Or Ends With A Specific Character In Excel?
  5. Split Text in One Cell into Two
  6. 5 WhatsApp Tricks You (Probably) Did Not Know
  7. With this iOS 14 trick you can quickly navigate through your Settings
  8. How to Setup and Use Focus Assist on Windows 10
  9. Apple Watch tips | 48 functions that you are not yet familiar with
  10. How to add entire folders to your Mac’s Dock
Comments
Loading...