• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Lookup query - based on multiple conditions
#1
Bestseller 
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)
  Reply
#2
Hi Amit,

Put the below formula in C13 cell and just copy into whole range (C13:F18)
=VLOOKUP(INDEX($A$3:$A$8,MATCH($B13,$B$3:$B$8,0)),$D$2:$L$8,MATCH(C$12,$D$2:$L$2,0),0)

Cheers!
Harshit
  Reply
#3
(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)
=VLOOKUP(INDEX($A$3:$A$8,MATCH($B13,$B$3:$B$8,0)),$D$2:$L$8,MATCH(C$12,$D$2:$L$2,0),0)

Cheers!
Harshit


Thank you Harshit..

Very well done...
  Reply


Related Topics
Topic Author Replies Views Last Post
  Formula duplicate values with conditions sanj_edu 2 1,241 03-Nov-2019, 10:44 PM
Last Post: sanj_edu
  Formula Pick Multiple Values From Single Identity @m!t $@!n! 2 1,533 12-Jun-2019, 12:40 AM
Last Post: @m!t $@!n!
  Formula MULTIPLE QUESTIONS virendra 2 1,376 04-May-2019, 09:50 PM
Last Post: virendra
  Formula V-lookup Question Amit Rawat 3 2,194 16-Oct-2018, 01:56 PM
Last Post: Vivekananda Sinha
  Formula Lookup Query @m!t $@!n! 1 1,644 29-Aug-2018, 12:19 PM
Last Post: devendra_dev20
  Formula If query FIH1232 2 1,792 24-Jul-2018, 07:43 PM
Last Post: FIH1232
  Formula Duplicate values Lookup formula in single time show Mohit Sharma 2 2,129 23-Jul-2018, 09:22 AM
Last Post: Mohit Sharma
  Formula Lookup formula Praveen Kr. Gupta 7 3,773 03-Feb-2018, 04:31 PM
Last Post: ARUN SHARMA
  Conditional Formatting Count of duplicate value as single, on condition based Dharmesh Kumar Srivastava 1 2,006 18-Oct-2017, 04:04 PM
Last Post: Mohit Sharma
  Formula Condition based status update Dharmesh Kumar Srivastava 8 4,875 16-Oct-2017, 05:15 AM
Last Post: HARIOMSINGH
  Formula Lookup data but have no unique value Dharmesh Kumar Srivastava 7 4,417 28-Sep-2017, 09:39 PM
Last Post: Lovedeep sharma
  Formula Conditions Query Manish Kumar Gera 4 3,137 13-Sep-2017, 10:44 PM
Last Post: Manish Kumar Gera
  Formula lOOKUP WITH MERGED CELL Dharmesh Kumar Srivastava 2 2,635 10-Aug-2017, 05:18 PM
Last Post: Dharmesh Kumar Srivastava
  Conditional Formatting Conditions format Yogesh kumar 2 2,960 29-Jun-2017, 07:48 PM
Last Post: Lovedeep sharma
  Formula Sum Query Manish Kumar Gera 4 3,319 04-Jun-2017, 09:56 PM
Last Post: Vivekananda Sinha

Forum Jump:


Users browsing this topic: 1 Guest(s)