James.xlsx

<div>
apologies for late reply... big thanks
</div>


<div>
No problem.<br />
You're welcome. Glad I could help.
</div>


No problem.
You're welcome. Glad I could help.

<div>
<div class="content wysiwyg-content">
Hello I am sure you guys can help....<br />
<br />
I have a sheet called data fill with 3000 rows<br />
Man &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Model &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>Code</b><br />
Acer &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A1-713 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Beetle_GSM<br />
Acer &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A1-811 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;111wv82_ht_qhd<br />
Acer &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A1-830 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ducati<br />
<br />
and another sheet called mobile which 100rows<br />
Date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Package Name &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<b>Device</b><br />
01/01/2016 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;com.djhajsd.android.wm &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;111wv82_ht_qhd<br />
01/01/2016 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;com.djhajsd.android.wm &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;A0001<br />
01/01/2016 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;com.djhajsd.android.wm &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Beetle_GSM<br />
<br />
<br />
what i need is Column in Data L2 to show me Model based on &nbsp;mobile c2 &nbsp;&quot;Device&quot; matching Data &quot;Code&quot;
</div>
</div>


Hello I am sure you guys can help....

I have a sheet called data fill with 3000 rows
Man  	Model	Code
Acer	A1-713	Beetle_GSM
Acer	A1-811	111wv82_ht_qhd
Acer	A1-830	ducati

and another sheet called mobile which 100rows
Date	         Package Name	               Device
01/01/2016	com.djhajsd.android.wm	111wv82_ht_qhd
01/01/2016	com.djhajsd.android.wm	A0001
01/01/2016	com.djhajsd.android.wm	Beetle_GSM


what i need is Column in Data L2 to show me Model based on  mobile c2  "Device" matching Data "Code"

look up from one sheet to next

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.