HLOOKUP In EXCEL
|
|
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
ORDER
|
10247
|
10249
|
10250
|
10251
|
20252
|
10253
|
|
$16.00
|
|
2
|
ID
|
$14.00
|
$18.00
|
$7.00
|
$16.00
|
$16.80
|
$64.00
|
|
6
|
|
3
|
QUANTITY
|
12
|
9
|
10
|
6
|
20
|
40
|
|
$14.00
|
FORMULAS:
PASTE THIS FORMULA IN D1 CELL.
=HLOOKUP(10251,A1:G3,2,FALSE)
PASTE THIS FORMULA IN D2 CELL
=HLOOKUP(10251,A1:G3,3,FALSE)
PASTE THIS FORMULA IN D3 CELL
=HLOOKUP(10247,A1:G3,2,TRUE)
Comments
Post a Comment