Learn all  about Microsoft Excel !   

Microsoft Excel  Do you need specific attention ?

Learn all  about  Outlook !  

Microsoft Outlook Do you need specific attention ?

Learn all  about Microsoft PowerPoint ! 

       

Microsoft Powerpoint  Do you need specific attention ?  

Learn all  about Power BI ! 

Microsoft Power bi   Do you need specific attention ?

     Learn all about Microsoft Access ! 

Microsoft Access  Do you need specific attention ?

use VLOOKUP - HLOOKUP functions Excel (part 2), enjoy this free lesson Excel 2017

Call VLOOKUP - HLOOKUP functions on Excel 
HLOOKUP:  this  function allows  to search values based  on horizontal criteria, in generally  this  will be based  on  columns titles.
To understand  better all  its  components'  signification , you have the below  explanation:
When we  applied  this function on our  previous  example here below how  the  result  will be like: 


 And  remainder  how was it the  last  time  with  VLookup's  example, see here below again   how  was  this function  written.



So, it  is  better  to  applied  the  VLookup function  when you have more than  1 Vertical  criteria   and   your  landmark is  the lines’  titles, but   in  the  other  hand,  the  Hlookup's function  will  be useful  when you have more than  1 horizontal criteria   and   your  landmark is  the columns’  titles..

Thanks for reading and try it by yourself. 
Will be glad to see your comments.