• 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
VLOOKUP formula
#1
Hi,

Kindly help me out on the below attached sheet.

Regards
Deepak Singh


Attached Files
.xlsx   output.xlsx (Size: 11.01 KB / Downloads: 18)
  Reply
#2
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
  Reply
#3
(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
  Reply
#4
(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
  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)