| 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: 325 times
CAclubindia
