Future in Hands club     Office Productivity     Microsoft Office     Microsoft Excel     Microsoft Excel Stuffs     Ask Excel Question    Formula Lookup data but have no unique value
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Lookup data but have no unique value
Dharmesh Kumar Srivastava
Lets begin to rock

Beginner
Joined: Apr 2017
Posts: 39

Reputation: 0
#1
26-Sep-2017, 03:18 PM (This post was last modified: 30-Sep-2017, 11:13 AM by Vivekananda Sinha.)
Guys I want to lookup all value in one criteria but have no any unique value.


Attached Files
.xlsx   Book1SSSS.xlsx (Size: 10.12 KB / Downloads: 14)
  Find
  Reply
Manish Kumar Gera
Lets begin to rock

Beginner
Joined: Apr 2017
Posts: 35

Reputation: 0
#2
27-Sep-2017, 07:16 AM (This post was last modified: 27-Sep-2017, 07:38 AM by Manish Kumar Gera.)
Hi Dharmesh,

Please find the attached file with your desired output......Once you change the value then you will get the output which you want from data.... :D
Hi Dharmesh,

Please ignore my last reply.. I need to change in formula for your desired output.... ;)


Attached Files
.xlsx   LookUp.xlsx (Size: 11.13 KB / Downloads: 11)
  Find
  Reply
Lokesh GUPTA
Lets begin to rock

Beginner
Joined: Jul 2017
Posts: 31

Reputation: 0
#3
27-Sep-2017, 11:28 AM
(26-Sep-2017, 03:18 PM)Dharmesh Kumar Srivastava Wrote: Guys I want to lookup all value in one criteria but have no any unique value.

Dear Dharmesh 

Please find the attachment for solution 

Regards.

Lokesh


Attached Files
.xlsx   Book1SSSS.xlsx (Size: 10.97 KB / Downloads: 10)
  Find
  Reply
Dharmesh Kumar Srivastava
Lets begin to rock

Beginner
Joined: Apr 2017
Posts: 39

Reputation: 0
#4
27-Sep-2017, 02:53 PM
Thanks Lokesh!!

But you can see as entry some client name is repeated so when i select the client name fill all entrys as prsnt in data.
  Find
  Reply
Lokesh GUPTA
Lets begin to rock

Beginner
Joined: Jul 2017
Posts: 31

Reputation: 0
#5
27-Sep-2017, 04:27 PM
(27-Sep-2017, 02:53 PM)Dharmesh Kumar Srivastava Wrote: Thanks Lokesh!!

But you can see as entry some client name is repeated so when i select the client name fill all entrys as prsnt in data.

Dear Sir,

Same is to be happened in MANISH JI ANSWER.

Regards,

Lokesh
  Find
  Reply
Lovedeep sharma
More to Achieve

Proficient
Joined: Apr 2017
Posts: 132

Reputation: 45
#6
27-Sep-2017, 09:30 PM (This post was last modified: 27-Sep-2017, 09:44 PM by Lovedeep sharma. Edit Reason: text not visible )
Hi,

please find the attached solution


Attached Files
.xlsx   Book1SSSS_Dharmesh Kumar Srivastava.xlsx (Size: 11.46 KB / Downloads: 11)
  Find
  Reply
Dharmesh Kumar Srivastava
Lets begin to rock

Beginner
Joined: Apr 2017
Posts: 39

Reputation: 0
#7
28-Sep-2017, 12:29 PM
Thanks! Lovedeep you are little bit close.. ;)

" INDIRECT(ADDRESS(IF($B$16="ABC2",5,IF($B$16="ABC1",3,IF($B$16="ABC3",6,IF($B$16="ABC4",7) "

but its working when you have specific data...

I have in specific client name..

then I chose one client name by drop box... and ush ki complete activity aa jaye..
  Find
  Reply
Lovedeep sharma
More to Achieve

Proficient
Joined: Apr 2017
Posts: 132

Reputation: 45
#8
28-Sep-2017, 09:39 PM
This question is very similar to one we have already discussed in club on this issue a few weeks ago
Please follow below link
http://club.futureinhands.com/Thread-excel-data-fetched

http://club.futureinhands.com/Thread-exc...rent-sheet
  Find
  Reply


Related Topics
Topic Author Replies Views Last Post
  Formula V-lookup Question Amit Rawat 3 2,978 16-Oct-2018, 01:56 PM
Last Post: Vivekananda Sinha
  Formula Lookup Query @m!t $@!n! 1 2,211 29-Aug-2018, 12:19 PM
Last Post: devendra_dev20
  Formula Duplicate values Lookup formula in single time show Mohit Sharma 2 3,003 23-Jul-2018, 09:22 AM
Last Post: Mohit Sharma
Bestseller Formula Lookup query - based on multiple conditions Amit Rawat 2 2,944 16-Jul-2018, 05:05 PM
Last Post: Amit Rawat
  Formula Lookup formula Praveen Kr. Gupta 7 5,317 03-Feb-2018, 04:31 PM
Last Post: ARUN SHARMA
  Formula Count Unique city and query related to date Shankardeep 1 2,669 19-Oct-2017, 09:57 AM
Last Post: Lovedeep sharma
  Formula ROW UNIQUE & NAME HARIOMSINGH 1 2,335 16-Oct-2017, 11:42 PM
Last Post: Vivekananda Sinha
  Formula Unique value Vinay kumar 1 2,228 12-Oct-2017, 11:24 PM
Last Post: Lovedeep sharma
  Formula lOOKUP WITH MERGED CELL Dharmesh Kumar Srivastava 2 3,345 10-Aug-2017, 05:18 PM
Last Post: Dharmesh Kumar Srivastava
  Formula how to apply vlookup in case of different formats of lookup value Deepika Khanna 2 4,101 01-May-2017, 04:58 PM
Last Post: Deepika Khanna

Forum Jump:


Users browsing this topic: 1 Guest(s)