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,611 06-Jul-2020, 11:51 AM
Last Post: dsharma789@rediffmail.com
Special-offer Formula vlookup virendra 1 2,192 18-Nov-2019, 04:44 PM
Last Post: Chetan@FIH
  Formula VLOOKUP sukhwantsingh23 3 2,950 15-Nov-2019, 09:44 PM
Last Post: Chetan@FIH
  Formula IF Formula Aman Kumar 1 2,120 27-Sep-2019, 08:40 PM
Last Post: Vivekananda Sinha
  Formula If with vlookup for time ( HH:MM:SS) Amit5210 0 1,623 06-Jun-2019, 05:54 PM
Last Post: Amit5210
  Formula Formula Inderjeet Pal 1 2,390 12-Mar-2019, 03:19 PM
Last Post: Chandan kumar
  Formula Vlookup Issue Jyoti 1 2,234 06-Mar-2019, 02:58 PM
Last Post: Vivekananda Sinha
  Formula Vlookup Rehman234 1 2,148 30-Dec-2018, 04:06 PM
Last Post: rawat7838
  Data Filtering Vlookup With Rank @m!t $@!n! 1 2,414 10-Nov-2018, 05:02 PM
Last Post: Vivekananda Sinha
  Formula Vlookup Query @m!t $@!n! 5 4,189 08-Nov-2018, 06:45 AM
Last Post: @m!t $@!n!
  Formula VLookup Related Question Aman Kumar 3 3,426 29-Oct-2018, 08:07 PM
Last Post: Vivekananda Sinha
  Formula Vlookup Skills Amitg9595 2 2,654 21-Oct-2018, 08:07 PM
Last Post: devendra_dev20
Thumbs Up Formula Vlookup questions Amitg9595 1 2,563 06-Oct-2018, 07:35 PM
Last Post: devendra_dev20
  Data Filtering Query: Vlookup: Extract Number From Data @m!t $@!n! 3 3,861 10-Aug-2018, 10:53 PM
Last Post: @m!t $@!n!
  Formula Query: Vlookup: Exact Result Not Found @m!t $@!n! 3 3,382 02-Aug-2018, 03:30 PM
Last Post: Shiva Bairwa

Forum Jump:


Users browsing this topic: 1 Guest(s)