• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Lookup data but have no unique value
#1
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)
  Reply
#2
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)
  Reply
#3
(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)
  Reply
#4
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.
  Reply
#5
(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
  Reply
#6
Hi,

please find the attached solution


Attached Files
.xlsx   Book1SSSS_Dharmesh Kumar Srivastava.xlsx (Size: 11.46 KB / Downloads: 11)
  Reply
#7
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..
  Reply
#8
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
  Reply


Related Topics
Topic Author Replies Views Last Post
  Formula V-lookup Question Amit Rawat 3 2,089 16-Oct-2018, 01:56 PM
Last Post: Vivekananda Sinha
  Formula Lookup Query @m!t $@!n! 1 1,587 29-Aug-2018, 12:19 PM
Last Post: devendra_dev20
  Formula Duplicate values Lookup formula in single time show Mohit Sharma 2 2,051 23-Jul-2018, 09:22 AM
Last Post: Mohit Sharma
Bestseller Formula Lookup query - based on multiple conditions Amit Rawat 2 1,922 16-Jul-2018, 05:05 PM
Last Post: Amit Rawat
  Formula Lookup formula Praveen Kr. Gupta 7 3,617 03-Feb-2018, 04:31 PM
Last Post: ARUN SHARMA
  Formula Count Unique city and query related to date Shankardeep 1 1,945 19-Oct-2017, 09:57 AM
Last Post: Lovedeep sharma
  Formula ROW UNIQUE & NAME HARIOMSINGH 1 1,736 16-Oct-2017, 11:42 PM
Last Post: Vivekananda Sinha
  Formula Unique value Vinay kumar 1 1,648 12-Oct-2017, 11:24 PM
Last Post: Lovedeep sharma
  Formula lOOKUP WITH MERGED CELL Dharmesh Kumar Srivastava 2 2,565 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 3,260 01-May-2017, 04:58 PM
Last Post: Deepika Khanna

Forum Jump:


Users browsing this topic: 1 Guest(s)