7/21/2019 Vlookup Si Dropdown List Instructiuni

http://slidepdf.com/reader/full/vlookup-si-dropdown-list-instructiuni 1/3

Sales 1 2

Finance 4 3

Beton 2 5

Otel 2 2

Finance 3

Otel 2

=VLOOKUP(38, A2:

If you know t! !!t! t! -!#+t"nu"! 38, you *

&!+*!& fo t!t! +$u! t+t & *

7/21/2019 Vlookup Si Dropdown List Instructiuni

http://slidepdf.com/reader/full/vlookup-si-dropdown-list-instructiuni 2/3

  10, 3, FALSE).

#$oy!!%& I' nu"!, you *+n u&! t! VLOOKUP fun*ton to !tun!nt o t! n+"! of t+t !"#$oy!!. /o ot+n t! n+"! of !"#$oy!!n u&! t! fo"u$+ =VLOOKUP(38, A2:C10, 3, FALSE). /& fo"u$+

+$u! 38 n t! &t *o$u"n of t! +n! A2:C10, +n- t!n !tun&ont+n!- n t! t- *o$u"n of t! +n! +n- on t! &+"! ow +&t! $ooku# +$u! (A4!$ '!$+-o).

7/21/2019 Vlookup Si Dropdown List Instructiuni

http://slidepdf.com/reader/full/vlookup-si-dropdown-list-instructiuni 3/3

A 1 2 3

B 2 3 4

C 5 6 7

D 2 3 4

D 2 3 4