Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

VLOOKUP & HLOOKUP


What is Vlookup?

  Vlookup means vertically looking up for something and bring corresponding details
  • You can use Vlookup to search for a value in the first column of the table.
  • It returns a value in the same row based on the column index number specified. 
  

What is Hlookup?

   Hlookup means horizontal lookup, It is easy to understand Hlookup once  you understand Vlookup.
 

Syntax for Vlookup


  Example for  Vlookup in Google Sheets

 

Syntax for Hlookup 


Example for Hlookup in Google Sheets