أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
this question was answered before ,
Vlookup is used to find value in different file or sheet and return the value related from the same raw
for example :
=VLOOKUP(A2,'Subscribers Bandwidth'!G:G,1,0)
the above statement will search for value A2 in sheet 'Subscribers Bandwidth' in column G and then return the same value if found.
=VLOOKUP(A2,'Subscribers Bandwidth'!G:G,2,0)
the above statement will search for value A2 in sheet 'Subscribers Bandwidth' in column G and then return the NEXT value in raw if found.
hope this was clear
Simply
The function vlookup
Used for
Find the value in the column at the left of the table
Then return the value located in the same row of the column you specify
***
the table must be in order by default
Formula
=vlookup(lookup_value;table array ;col_index_num;rang_lookup)
Example
Column A contains1,2,3,4
Column B contains a kk, ll, nn.mm
And when you want to put number in cell c1 shows each value that appears in the same row in a cell d1
The equation which is written in d1
= (VLOOKUP (C1; $ A $1: $ B $4;2;0)
When c1 contains2'll get "ll "
When c1 with4 'll get "mm"
note*************
when you will get C1 empty the result will be in # N / A that means that the value of c1 cell non-existent in column a spicfied array
