أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
vlookup is used to collect data connected with a set of values. vlookup finds the values in column in another range of cells and returns the required data related with it.
eg:
Target range
ColumnA ColumnB D 100 A 500 B 200 C 700
We need to get the result with the following order
Result with output
column C ColumnD A 500 B 200 C 700 D 100
On column C we enter the data and we need to get the result matching on column D
Here the formula on cell number D1 should be as , =vlookup(c1,$a$1:$b$4,1,false) which will pick the value in the1st right cell next to A1 ;500
this is gonna sound weird, but check the following site:
http://howtovlookupinexcel.com/
