Easy way to make hlookup in excel

HLOOKUP function is almost the same with the vlookup function. The Difference is the data source in hlookup function arranged horizontally.

1) Create a table as below.

Picture 01. Simple table data

2) Insert function =HLOOKUP in cell H4. Don’t forget to make it absolute.

Before

=HLOOKUP(G4,B4:D5,2,FALSE)

Change B4:D5 into absolute by pressing F4

After (Absolute)

=HLOOKUP(G4,$B$4:$D$5,2,FALSE) [enter]

Picture 02. Insert function

3) Test insert data in cell G4, do for all data items. If successful, drag the function to another column.

Picture 03. Test function

By adding data validation, we don't need to type the data one by one. Data validation will limit the data area according to the data table range.

1) Click DATA and select the Data Validation excel

Picture no. 04 Data validation

2) It comes Data Validation window.

Picture 05. Data validation window

Note:

Select list in Allow column

Select the data source by clicking on the red arrow in the column source [ $B$4:$D$4 ]

Then click OK

degineering