Future in Hands club     Office Productivity     Microsoft Office     Microsoft Excel     Microsoft Excel Stuffs     Ask Excel Question    Formula Duplicate values Lookup formula in single time show
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Duplicate values Lookup formula in single time show
Mohit Sharma
Lets begin to rock

Beginner
Joined: Apr 2017
Posts: 67

Reputation: 30
#1
19-Jul-2018, 10:07 PM (This post was last modified: 20-Jul-2018, 03:09 PM by Admin.)
Hi Team,

I have a two worksheets in excel workbooks 1. Data 2. Master data. i want to fetch values with formula in master data sheets but the problem is Data sheet Emp code multiple times and Master data in single time so i want to formula fetch values in single times in data sheets each record, because there are duplicate values.

Please solve it. i have attached the worksheets and desired result clarification in worksheets.


Attached Files
.xlsx   Book2 (2).xlsx (Size: 11.93 KB / Downloads: 13)
  Find
  Reply
Vivekananda Sinha
The next innovation

Mentor
Joined: Apr 2017
Posts: 590

Reputation: 0

Location: Delhi
#2
20-Jul-2018, 03:23 PM
Dear Mohit,

Please find the attached solution.


Attached Files
.xlsx   Book2 (2).xlsx (Size: 13.12 KB / Downloads: 31)
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Website   Find
  Reply
Mohit Sharma
Lets begin to rock

Beginner
Joined: Apr 2017
Posts: 67

Reputation: 30
#3
23-Jul-2018, 09:22 AM
(20-Jul-2018, 03:23 PM)Vivekananda Sinha Wrote: Dear Mohit,

Please find the attached solution.

Thank you very much Sir for your Quick Response. Smile
  Find
  Reply


Related Topics
Topic Author Replies Views Last Post
  Data Filtering PAN NO. FORMULA dsharma789@rediffmail.com 0 1,452 06-Jul-2020, 11:51 AM
Last Post: dsharma789@rediffmail.com
  Formula duplicate values with conditions sanj_edu 2 1,921 03-Nov-2019, 10:44 PM
Last Post: sanj_edu
  Formula IF Formula Aman Kumar 1 1,908 27-Sep-2019, 08:40 PM
Last Post: Vivekananda Sinha
  Formula Pick Multiple Values From Single Identity @m!t $@!n! 2 2,199 12-Jun-2019, 12:40 AM
Last Post: @m!t $@!n!
  Formula If with vlookup for time ( HH:MM:SS) Amit5210 0 1,469 06-Jun-2019, 05:54 PM
Last Post: Amit5210
  Pivot Table How to make dynamic two RAW switch in single Pivot Amitg9595 0 1,476 01-Jun-2019, 05:11 PM
Last Post: Amitg9595
  Formula Formula Inderjeet Pal 1 2,178 12-Mar-2019, 03:19 PM
Last Post: Chandan kumar
  Formula V-lookup Question Amit Rawat 3 2,978 16-Oct-2018, 01:56 PM
Last Post: Vivekananda Sinha
  Formula Large Function with Duplicate check Amit sharma 2 2,527 06-Oct-2018, 07:47 PM
Last Post: devendra_dev20
  Others Time Calculation Amit Rawat 1 1,987 17-Sep-2018, 10:07 PM
Last Post: Lovedeep sharma
  Formula VLOOKUP formula Deepaksingh 3 3,495 29-Aug-2018, 07:43 PM
Last Post: Deepaksingh
  Formula Lookup Query @m!t $@!n! 1 2,211 29-Aug-2018, 12:19 PM
Last Post: devendra_dev20
Zoom Formula Vllokup formula Deepaksingh 1 2,368 31-Jul-2018, 09:40 PM
Last Post: Vivekananda Sinha
Bestseller Formula Lookup query - based on multiple conditions Amit Rawat 2 2,944 16-Jul-2018, 05:05 PM
Last Post: Amit Rawat
  Formula Need a single formula for entire row Shiva Bairwa 3 3,032 04-Jul-2018, 12:22 PM
Last Post: Vivekananda Sinha

Forum Jump:


Users browsing this topic: 1 Guest(s)