• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Lookup query - based on multiple conditions
Hi Sir,

I need the solution in attached sheet.

As I have the four table which contains the employee's details like the product, date of joining month, Designation and employee Id and the basis of the tables i need the result through names instead of the employee id.

Note:- Please design the dynamic formula so that we can change the header as well. Don’t change the sequence of the questioning table. I mean no arranging allowed of employee details.

Attached Files
.xlsx   Vlookup.xlsx (Size: 10.91 KB / Downloads: 33)
Hi Amit,

Put the below formula in C13 cell and just copy into whole range (C13:F18)

(16-Jul-2018, 11:10 AM)Harshit Wrote: Hi Amit,

Put the below formula in C13 cell and just copy into whole range (C13:F18)


Thank you Harshit..

Very well done...

Related Topics
Topic Author Replies Views Last Post
  Formula duplicate values with conditions sanj_edu 2 1,592 03-Nov-2019, 10:44 PM
Last Post: sanj_edu
  Formula Pick Multiple Values From Single Identity @m!t $@!n! 2 1,882 12-Jun-2019, 12:40 AM
Last Post: @m!t $@!n!
  Formula MULTIPLE QUESTIONS virendra 2 1,719 04-May-2019, 09:50 PM
Last Post: virendra
  Formula V-lookup Question Amit Rawat 3 2,626 16-Oct-2018, 01:56 PM
Last Post: Vivekananda Sinha
  Formula Lookup Query @m!t $@!n! 1 1,972 29-Aug-2018, 12:19 PM
Last Post: devendra_dev20
  Formula If query FIH1232 2 2,218 24-Jul-2018, 07:43 PM
Last Post: FIH1232
  Formula Duplicate values Lookup formula in single time show Mohit Sharma 2 2,668 23-Jul-2018, 09:22 AM
Last Post: Mohit Sharma
  Formula Lookup formula Praveen Kr. Gupta 7 4,720 03-Feb-2018, 04:31 PM
  Conditional Formatting Count of duplicate value as single, on condition based Dharmesh Kumar Srivastava 1 2,493 18-Oct-2017, 04:04 PM
Last Post: Mohit Sharma
  Formula Condition based status update Dharmesh Kumar Srivastava 8 5,911 16-Oct-2017, 05:15 AM
  Formula Lookup data but have no unique value Dharmesh Kumar Srivastava 7 5,371 28-Sep-2017, 09:39 PM
Last Post: Lovedeep sharma
  Formula Conditions Query Manish Kumar Gera 4 3,729 13-Sep-2017, 10:44 PM
Last Post: Manish Kumar Gera
  Formula lOOKUP WITH MERGED CELL Dharmesh Kumar Srivastava 2 3,064 10-Aug-2017, 05:18 PM
Last Post: Dharmesh Kumar Srivastava
  Conditional Formatting Conditions format Yogesh kumar 2 3,380 29-Jun-2017, 07:48 PM
Last Post: Lovedeep sharma
  Formula Sum Query Manish Kumar Gera 4 3,874 04-Jun-2017, 09:56 PM
Last Post: Vivekananda Sinha

Forum Jump:

Users browsing this topic: 1 Guest(s)