Future in Hands club     Office Productivity     Microsoft Office     Microsoft Excel     Microsoft Excel Stuffs     Ask Excel Question    Formula lOOKUP WITH MERGED CELL
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
lOOKUP WITH MERGED CELL
Dharmesh Kumar Srivastava
Lets begin to rock

Beginner
Joined: Apr 2017
Posts: 39

Reputation: 0
#1
10-Aug-2017, 11:58 AM
Hello Guys!


I received data with merged cell and whenever I try to lookup with other sheet data are coming with blank row (count of merged cell). So now I want my data are placed without blank..

sheet has been attached!!


Attached Files
.xlsx   Book1.xlsx (Size: 10.42 KB / Downloads: 17)
  Find
  Reply
Sanjay Sengar
Lots of things to do

Fresher
Joined: Jul 2017
Posts: 6

Reputation: 10
#2
10-Aug-2017, 01:31 PM
(10-Aug-2017, 11:58 AM)Dharmesh Kumar Srivastava Wrote: Hello Guys!


I received data with merged cell and whenever I try to lookup with other sheet data are coming with blank row (count of merged cell). So now I want my data are placed without blank..

sheet has been attached!!


PLEASE FIND ATTACHED FILE


Attached Files
.xlsx   SOLUTION.xlsx (Size: 11.28 KB / Downloads: 27)
  Find
  Reply
Dharmesh Kumar Srivastava
Lets begin to rock

Beginner
Joined: Apr 2017
Posts: 39

Reputation: 0
#3
10-Aug-2017, 05:18 PM
(10-Aug-2017, 01:31 PM)Sanjay Sengar Wrote:
(10-Aug-2017, 11:58 AM)Dharmesh Kumar Srivastava Wrote: Hello Guys!


I received data with merged cell and whenever I try to lookup with other sheet data are coming with blank row (count of merged cell). So now I want my data are placed without blank..

sheet has been attached!!


PLEASE FIND ATTACHED FILE
Sanjay ji..

Its not like that which is I want.. and also you taken wrong input.

I lookup with merged cell which is show up side.. check my excel again.

(Mujhe jaisa result chahiye aap ne ush pr hi lookup laga diya hain.)
  Find
  Reply


Related Topics
Topic Author Replies Views Last Post
  Formula Count the number in one cell Amit Dhankar 4 3,499 10-Feb-2019, 12:10 AM
Last Post: Amit Dhankar
  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 Separate the data in Cell Manpreet Kaur 3 3,367 03-Feb-2018, 04:38 PM
Last Post: ARUN SHARMA
  Formula Lookup formula Praveen Kr. Gupta 7 5,317 03-Feb-2018, 04:31 PM
Last Post: ARUN SHARMA
  Formula Numbering in Filtered cell MUNEESH KUMAR 3 2,957 06-Jan-2018, 07:38 PM
Last Post: sanj_edu
  Others How to merged table in excel Dharmesh Kumar Srivastava 1 2,527 12-Nov-2017, 06:17 PM
Last Post: Vivekananda Sinha
  Formula Lookup data but have no unique value Dharmesh Kumar Srivastava 7 5,996 28-Sep-2017, 09:39 PM
Last Post: Lovedeep sharma
  Formula HOW TO DIVIDE DATA IN TWO CELL BY USING FORMULA Lokesh GUPTA 1 2,716 16-Sep-2017, 04:03 PM
Last Post: Dayal Singh
  Formula hide cell Yogesh kumar 2 3,574 09-Sep-2017, 01:24 PM
Last Post: Virender
  Formula Numbers in a cell Manish Kumar Gera 5 5,652 02-Sep-2017, 08:46 PM
Last Post: Shreyashi Sinha
  Others How to Freeze particular data in particular cell Aman Kumar 1 2,735 02-May-2017, 01:50 PM
Last Post: Vivekananda Sinha
  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)