• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Lookup formula
#1
Hi,
  Can anyone help me to solve this.


Attached Files
.xlsx   Query Pr.xlsx (Size: 9.14 KB / Downloads: 15)
  Reply
#2
(30-Jan-2018, 03:42 PM)Praveen Kr. Gupta Wrote: Hi,
  Can anyone help me to solve this.


Attached Files
.xlsx   Query Pr.xlsx (Size: 9.91 KB / Downloads: 15)
  Reply
#3
(30-Jan-2018, 04:54 PM)Naveen Katiyar Wrote:
(30-Jan-2018, 03:42 PM)Praveen Kr. Gupta Wrote: Hi,
  Can anyone help me to solve this.

Thanks for contribution mr, Naveen but i want to find 2,1,31 from the range contain 2b, 1amit and 31c
 output  like b, amit, c .....
  Reply
#4
(30-Jan-2018, 05:29 PM)Praveen Kr. Gupta Wrote:
(30-Jan-2018, 04:54 PM)Naveen Katiyar Wrote:
(30-Jan-2018, 03:42 PM)Praveen Kr. Gupta Wrote: Hi,
  Can anyone help me to solve this.

Thanks for contribution mr, Naveen but i want to find 2,1,31 from the range contain 2b, 1amit and 31c
 output  like b, amit, c .....
Please Call 9811888123
  Reply
#5
Pls find the solution


Attached Files
.xlsx   Query Pr.xlsx (Size: 13.89 KB / Downloads: 13)
  Reply
#6
(30-Jan-2018, 03:42 PM)Praveen Kr. Gupta Wrote:
.xlsx   Query Pr_Solution.xlsx (Size: 9.92 KB / Downloads: 8) Hi,
  Can anyone help me to solve this.

Hi,
Please find the attached solution.

Thanks,
Sanjay(9999051340)


Attached Files Image(s)
   
  Reply
#7
Hi,
  Thanks to everyone for participation. Finally I solved this Query.
  Find the attachment which have been solved with vlookup function.


Attached Files
.xlsx   Query Pr.xlsx (Size: 9.76 KB / Downloads: 9)
  Reply
#8
(30-Jan-2018, 03:42 PM)Praveen Kr. Gupta Wrote: Hi,
  Can anyone help me to solve this.

1. use this for  number finding dynamic :- =SUMPRODUCT(MID(0&D4,LARGE(INDEX(ISNUMBER(--MID(D4,ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)

2. use this for text finding dynamic:- =SUBSTITUTE(D4,SUMPRODUCT(MID(0&D4,LARGE(INDEX(ISNUMBER(--MID(D4,ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10),"")
  Reply


Related Topics
Topic Author Replies Views Last Post
  Data Filtering PAN NO. FORMULA dsharma789@rediffmail.com 0 835 06-Jul-2020, 11:51 AM
Last Post: dsharma789@rediffmail.com
  Formula IF Formula Aman Kumar 1 1,226 27-Sep-2019, 08:40 PM
Last Post: Vivekananda Sinha
  Formula Formula Inderjeet Pal 1 1,457 12-Mar-2019, 03:19 PM
Last Post: Chandan kumar
  Formula V-lookup Question Amit Rawat 3 2,089 16-Oct-2018, 01:56 PM
Last Post: Vivekananda Sinha
  Formula VLOOKUP formula Deepaksingh 3 2,423 29-Aug-2018, 07:43 PM
Last Post: Deepaksingh
  Formula Lookup Query @m!t $@!n! 1 1,587 29-Aug-2018, 12:19 PM
Last Post: devendra_dev20
Zoom Formula Vllokup formula Deepaksingh 1 1,613 31-Jul-2018, 09:40 PM
Last Post: Vivekananda Sinha
  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 Formula for scheduling Inderjeet Pal 1 1,787 18-Jan-2018, 08:32 PM
Last Post: Vivekananda Sinha
  Formula Formula MUNEESH KUMAR 2 2,089 03-Jan-2018, 03:43 PM
Last Post: MUNEESH KUMAR
  Formula Excel Formula Sujeet Singh 1 1,899 13-Oct-2017, 12:56 PM
Last Post: Vivekananda Sinha
  Formula Lookup data but have no unique value Dharmesh Kumar Srivastava 7 4,248 28-Sep-2017, 09:39 PM
Last Post: Lovedeep sharma
  Formula USING IF FORMULA Lokesh GUPTA 1 2,288 19-Sep-2017, 12:17 PM
Last Post: Vivekananda Sinha
  Formula lOOKUP WITH MERGED CELL Dharmesh Kumar Srivastava 2 2,565 10-Aug-2017, 05:18 PM
Last Post: Dharmesh Kumar Srivastava

Forum Jump:


Users browsing this topic: 1 Guest(s)