Updated Online video classes available for CA,CS,CMA for May20 and Nov20 batch. Call: 1800-3000-0505

30 excel functions in 30 days - hlookup function(just got si


CA CS CIMA* Prakash Somani (Landmark Group)     12 October 2012

CA CS CIMA* Prakash Somani
Landmark Group 
 2093 likes  23356 points

| My Other Post

 

Simple very useful tips which are compressed and easy to understand by anyone from begginer of excel to exceller of excel
  Hlookup is just similer to vookup        
  it’s a horizontal lookup          
  yet many find It difficult to use but its very simple      
  the process to use the same is defined below:      
               
               
Data w r t h o l  
Number 1 2 3 4 5 6  
channel sony star zee utv ttn color  
               
  Input Using Hlookup Using Vlookup      
Number h 4 4        
channel w sony sony        
               
The same can be done through transpose data and using vlookup    
               
  Data Number channel        
  w 1 sony        
  r 2 star        
  t 3 zee        
  h 4 utv        
  o 5 ttn        
  l 6 color        
               

 


Attached File : 25603 1069834 30fn30d hlookup function.xlsx downloaded: 276 times
2 Like
avater

Vandana Mulchandani (Finance Manager )     12 October 2012

Vandana Mulchandani
Finance Manager  
 2080 likes  9222 points

View Profile | My Other Post

Thank you Prakash Sir...very useful ...Keep sharing.


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  



Popular Discussion


view more »





Download the latest Question Papers for free

click here