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

Fresher
Joined: Jun 2018
Posts: 10

Reputation: 0
#1
10-Aug-2018, 08:53 PM (This post was last modified: 10-Aug-2018, 09:47 PM by Vivekananda Sinha.)
Hi,

Kindly help me out on the below attached sheet.

Regards
Deepak Singh


Attached Files
.xlsx   output.xlsx (Size: 11.01 KB / Downloads: 18)
  Find
  Reply
Vivekananda Sinha
The next innovation

Mentor
Joined: Apr 2017
Posts: 590

Reputation: 0

Location: Delhi
#2
10-Aug-2018, 09:46 PM
Dear Deepak,

Please find the attached solution.


Attached Files
.xlsx   output.xlsx (Size: 13 KB / Downloads: 28)
Regards,
Vivekananda Sinha

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

Beginner
Joined: Apr 2018
Posts: 44

Reputation: 40
#3
22-Aug-2018, 12:27 PM
(10-Aug-2018, 08:53 PM)Deepaksingh Wrote: Hi,

Kindly help me out on the below attached sheet.

Regards
Deepak Singh

Please find the attached Sheet...

Thanks
Devendra Adhikari
  Find
  Reply
Deepaksingh
Lots of things to do

Fresher
Joined: Jun 2018
Posts: 10

Reputation: 0
#4
29-Aug-2018, 07:43 PM
(10-Aug-2018, 09:46 PM)Vivekananda Sinha Wrote: Dear Deepak,

Please find the attached solution.
Hi sir,

Thank you for your reply, but this formula not working for if I am changing the position of header.

If I am changing the position of department or location, so its showing wrong information.

Regards
Deepak Singh
  Find
  Reply


Related Topics
Topic Author Replies Views Last Post
  Data Filtering PAN NO. FORMULA dsharma789@rediffmail.com 0 1,550 06-Jul-2020, 11:51 AM
Last Post: dsharma789@rediffmail.com
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 Formula Aman Kumar 1 2,037 27-Sep-2019, 08:40 PM
Last Post: Vivekananda Sinha
  Formula If with vlookup for time ( HH:MM:SS) Amit5210 0 1,563 06-Jun-2019, 05:54 PM
Last Post: Amit5210
  Formula Formula Inderjeet Pal 1 2,295 12-Mar-2019, 03:19 PM
Last Post: Chandan kumar
  Formula Vlookup Issue Jyoti 1 2,161 06-Mar-2019, 02:58 PM
Last Post: Vivekananda Sinha
  Formula Vlookup Rehman234 1 2,060 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,999 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,559 21-Oct-2018, 08:07 PM
Last Post: devendra_dev20
Thumbs Up Formula Vlookup questions Amitg9595 1 2,479 06-Oct-2018, 07:35 PM
Last Post: devendra_dev20
  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

Forum Jump:


Users browsing this topic: 1 Guest(s)