Future in Hands club     Office Productivity     Microsoft Office     Microsoft Excel     Microsoft Excel Stuffs     Ask Excel Question    Formula Vlookup Issue
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Vlookup Issue
Jyoti
Lots of things to do

Fresher
Joined: May 2018
Posts: 6

Reputation: 0
#1
05-Mar-2019, 01:31 PM (This post was last modified: 06-Mar-2019, 01:08 PM by Jyoti.)
Hello everyone,

Please help for solve this question, IN this question i have data in Sheet1 and i want data in sheet 2.


Attached Files
.xls   Excel question.xls (Size: 16.5 KB / Downloads: 12)
  Find
  Reply
Vivekananda Sinha
The next innovation

Mentor
Joined: Apr 2017
Posts: 590

Reputation: 0

Location: Delhi
#2
06-Mar-2019, 02:58 PM
Dear Jyoti,

I have used INDEX function with Array Formula. Please check the attached solution.


Attached Files
.xls   Excel question.xls (Size: 46 KB / Downloads: 10)
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Website   Find
  Reply


Related Topics
Topic Author Replies Views Last Post
Special-offer Formula vlookup virendra 1 2,094 18-Nov-2019, 04:44 PM
Last Post: Chetan@FIH
  Formula VLOOKUP sukhwantsingh23 3 2,796 15-Nov-2019, 09:44 PM
Last Post: Chetan@FIH
  Formula If with vlookup for time ( HH:MM:SS) Amit5210 0 1,563 06-Jun-2019, 05:54 PM
Last Post: Amit5210
  Formula Vlookup Rehman234 1 2,059 30-Dec-2018, 04:06 PM
Last Post: rawat7838
  Data Filtering Vlookup With Rank @m!t $@!n! 1 2,323 10-Nov-2018, 05:02 PM
Last Post: Vivekananda Sinha
  Formula Vlookup Query @m!t $@!n! 5 3,998 08-Nov-2018, 06:45 AM
Last Post: @m!t $@!n!
  Formula VLookup Related Question Aman Kumar 3 3,281 29-Oct-2018, 08:07 PM
Last Post: Vivekananda Sinha
  Formula Vlookup Skills Amitg9595 2 2,558 21-Oct-2018, 08:07 PM
Last Post: devendra_dev20
Thumbs Up Formula Vlookup questions Amitg9595 1 2,478 06-Oct-2018, 07:35 PM
Last Post: devendra_dev20
  Others Incentive Calcuation issue Ankush Sharma 4 3,375 17-Sep-2018, 07:49 PM
Last Post: Ankush Sharma
  Formula VLOOKUP formula Deepaksingh 3 3,697 29-Aug-2018, 07:43 PM
Last Post: Deepaksingh
  Data Filtering Query: Vlookup: Extract Number From Data @m!t $@!n! 3 3,736 10-Aug-2018, 10:53 PM
Last Post: @m!t $@!n!
  Formula Query: Vlookup: Exact Result Not Found @m!t $@!n! 3 3,267 02-Aug-2018, 03:30 PM
Last Post: Shiva Bairwa
  Pivot Table Range issue in pivot table Amit5210 3 3,887 30-May-2018, 03:38 PM
Last Post: Abhishek Jain
  Formula Query related to VLOOKUP sanjeevdba 1 2,357 27-May-2018, 06:07 PM
Last Post: Amit5210

Forum Jump:


Users browsing this topic: 1 Guest(s)