can any one guide me how to apply formula for merge cell and also to lookup the value in the merge cell.
can any one guide me how to apply formula for merge cell and also to lookup the value in the merge cell.
TIP: don't use merged cells. You will save yourself a lot of headaches.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
do we have any other option for this ..?
Oh, yes - what you are wanting can be done, but there isn't a generic fix. We shall need to see the layout of your workbook - attach a sample one here for us to look at.
But as I have advised, if you are at the design stage, ditch the merged cells: believe me, you will be glad you did.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks