Future in Hands club     Office Productivity     Microsoft Office     Microsoft Excel     Microsoft Excel Stuffs     Ask Excel Question    Formula Lookup formula
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Lookup formula
Praveen Kr. Gupta
Lots of things to do

Fresher
Joined: Nov 2017
Posts: 6

Reputation: 0
#1
30-Jan-2018, 03:42 PM
Hi,
  Can anyone help me to solve this.


Attached Files
.xlsx   Query Pr.xlsx (Size: 9.14 KB / Downloads: 15)
  Find
  Reply
Naveen Katiyar
Lots of things to do

Fresher
Joined: Oct 2017
Posts: 3

Reputation: 0
#2
30-Jan-2018, 04:54 PM
(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)
  Find
  Reply
Praveen Kr. Gupta
Lots of things to do

Fresher
Joined: Nov 2017
Posts: 6

Reputation: 0
#3
30-Jan-2018, 05:29 PM
(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 .....
  Find
  Reply
Naveen Katiyar
Lots of things to do

Fresher
Joined: Oct 2017
Posts: 3

Reputation: 0
#4
30-Jan-2018, 05:45 PM
(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
  Find
  Reply
Sanjeev Gupta
Lets begin to rock

Beginner
Joined: Apr 2017
Posts: 46

Reputation: 15
#5
30-Jan-2018, 08:22 PM
Pls find the solution


Attached Files
.xlsx   Query Pr.xlsx (Size: 13.89 KB / Downloads: 13)
  Find
  Reply
sanj_edu
Lets begin to rock

Beginner
Joined: Dec 2017
Posts: 33

Reputation: 10
#6
30-Jan-2018, 09:41 PM
(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)
   
  Find
  Reply
Praveen Kr. Gupta
Lots of things to do

Fresher
Joined: Nov 2017
Posts: 6

Reputation: 0
#7
01-Feb-2018, 11:16 PM
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)
  Find
  Reply
ARUN SHARMA
Lots of things to do

Fresher
Joined: Sep 2017
Posts: 7

Reputation: 0
#8
03-Feb-2018, 04:31 PM
(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),"")
  Find
  Reply


Related Topics
Topic Author Replies Views Last Post
  Data Filtering PAN NO. FORMULA dsharma789@rediffmail.com 0 1,453 06-Jul-2020, 11:51 AM
Last Post: dsharma789@rediffmail.com
  Formula IF Formula Aman Kumar 1 1,908 27-Sep-2019, 08:40 PM
Last Post: Vivekananda Sinha
  Formula Formula Inderjeet Pal 1 2,179 12-Mar-2019, 03:19 PM
Last Post: Chandan kumar
  Formula V-lookup Question Amit Rawat 3 2,979 16-Oct-2018, 01:56 PM
Last Post: Vivekananda Sinha
  Formula VLOOKUP formula Deepaksingh 3 3,495 29-Aug-2018, 07:43 PM
Last Post: Deepaksingh
  Formula Lookup Query @m!t $@!n! 1 2,211 29-Aug-2018, 12:19 PM
Last Post: devendra_dev20
Zoom Formula Vllokup formula Deepaksingh 1 2,368 31-Jul-2018, 09:40 PM
Last Post: Vivekananda Sinha
  Formula Duplicate values Lookup formula in single time show Mohit Sharma 2 3,004 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 Formula for scheduling Inderjeet Pal 1 2,604 18-Jan-2018, 08:32 PM
Last Post: Vivekananda Sinha
  Formula Formula MUNEESH KUMAR 2 3,081 03-Jan-2018, 03:43 PM
Last Post: MUNEESH KUMAR
  Formula Excel Formula Sujeet Singh 1 2,568 13-Oct-2017, 12:56 PM
Last Post: Vivekananda Sinha
  Formula Lookup data but have no unique value Dharmesh Kumar Srivastava 7 5,997 28-Sep-2017, 09:39 PM
Last Post: Lovedeep sharma
  Formula USING IF FORMULA Lokesh GUPTA 1 3,005 19-Sep-2017, 12:17 PM
Last Post: Vivekananda Sinha
  Formula lOOKUP WITH MERGED CELL Dharmesh Kumar Srivastava 2 3,345 10-Aug-2017, 05:18 PM
Last Post: Dharmesh Kumar Srivastava

Forum Jump:


Users browsing this topic: 1 Guest(s)