troubleshooting Question

look up from one sheet to next

Avatar of James Murrell
James MurrellFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Excel
3 Comments1 Solution73 ViewsLast Modified:
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      111wv82_ht_qhd
01/01/2016      A0001
01/01/2016      Beetle_GSM

what i need is Column in Data L2 to show me Model based on  mobile c2  "Device" matching Data "Code"
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 3 Comments.
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>


Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 3 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004