A Simple Computer Library

HLOOKUP and VLOOKUP

Practice 1

To fill up the Bonus in cell D2 and so on.
If we use Tabel 1, the formula is:
=HLOOKUP(C2,$G$2:$J$3,2)
If we use Tabel 2, the formula is:
=VLOOKUP(C2,$F$7:$G$10,2)

Practice 2

To fill up Name, the formula is:
=VLOOKUP(LEFT(A2,1),$A$8:$D$10,2)
To fill up Salary, the formula is:
=VLOOKUP(LEFT(A2,1),$A$8:$D$10,3)
To fill up Incentive, the formula is:
=VLOOKUP(LEFT(A2,1),$A$8:$D$10,4)
To fill up Bonus, if the two character code multiply by 100 is:
=RIGHT(A2,2)*100

Don’t forget to copy the formula to fill up the next row.
Note : Code have to sorted ascending in Table 1

Practice 3

To fill up JUICE NAME, the formula is:
=HLOOKUP(LEFT(B2,1),$B$13:$D$14,2)
To fill up SIZE, the formula is:
=MID(B2,2,3)
To fill up PACKAGE, the formula is:
=VLOOKUP(RIGHT(B2,1),$A$17:$C$19,2)
To fill up PRICE, the formula is:
=VLOOKUP(RIGHT(B2,1),$A$17:$C$19,3)