look up from one sheet to next

James Murrell
James Murrell used Ask the Experts™
on
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"
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Assuming the data on sheet1 is in the range A1:C4 and on Sheet2 is in the range A1:C4 then try this...
In D2
=IFERROR(INDEX(Sheet1!$B$2:$B$4,MATCH(C2,Sheet1!$C$2:$C$4,0)),"")

Open in new window

and copy it down.

Refer to the attache for details.
James.xlsx
James MurrellProduct Specialist

Author

Commented:
apologies for late reply... big thanks
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial