Link to home
Get AccessLog in
Avatar of James Murrell
James MurrellFlag for United Kingdom of Great Britain and Northern Ireland

asked on

look up from one sheet to next

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"
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of James Murrell

ASKER

apologies for late reply... big thanks
No problem.
You're welcome. Glad I could help.