Question 6
A
B
C
D
E
F
G
H
1
2
3
Sample No.
5210
5211
5212
5213
5214
4
Location
Australia
South Africa
India
Ukraine
Libya
5
Weight
16.90
8.70
43.80
12.30
17.90
6
Status
Active
Not Active
Active
Active
Not Active
7
8
9
10
You are interested in finding the weight for Sample 5213. Which of the following codes will give you the correct answer:
\textbullet{} =HLOOKUP(5213,B3:G6,3)
\textbullet{} =VLOOKUP(5213,B3:G6,3)
\textbullet{} =HLOOKUP("5213",B3:G6,4)
\textbullet{} =VLOOKUP(B3:G6,5213,3)