Question

Assume that in A1, A2, A3, and A4 you have the values of 1, 2, 3, and 4, respectively. In B1, C1, and D1, have the letters a, b, and c, respectively. In B2, C2, and D2 you have the letters of d, e, and f, respectively. In B3, C3, and D3 you have the letters of g, h, and i, respectively. What will the command of =VLOOKUP(3,A1:D4,3) return?

Group of answer choices

h

c

a

g

i

Answer 1

VlookUp is used to perform a vertical look up by searching a particular given value in the first column of the array/matrix and then return the value in same row in index_number position.

with parameters

=VLOOKUP (value, table, col_index, [range_lookup])

Given:

A B C D 1 a D 3/6

X fx =VLOOKUP(3,41:04,3) D E B C F G 1 SUM A 1 a 2d 38 4. | NM + b e h c f i VLOOKUP(3, A1:D4 ,3) 00

Painter A6 A B 1 1 a 2 ad 38 44 b le h @ fx =VLOOKUP(3,41:04,3) C D E F c If i

Hence correct answer is Option A -- (h)