B C D E F G H I J K L M N O        
2  
     
3        
4    
 
5     Show Formula:    
6      
7    
8     Hlookup Function  
 
9      
10     A B C D E  
11   378,476 490,836 121,957 43,213 28,060  
12   487,073 600,000 235,432 844,324 195,349  
13   500,000 856,434 454,334 968,593 548,588  
14   529,146 948,494 571,227 998,858 583,598  
15   600,000 989,859 660,300 958,969 822,342  
16          
17          
18    
19        
20        
21        
22        
23          
24          
25    
26     Hlookup Looks in the top row of an array and returns the value of the indicated cell.  
27          
28     Change the region at E17 and see the sales change.  
29    
30    
31    
32     This example is contributed by www.xlmacros.com.  
33    
34     Copyright.  Anthony's VBA Page.    
35    
36    
37    
38    
39    
40    
41    
42    
43        
44