• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

required a match formula

paramveer

Member
Sir,
In attached workbook contain many sheets. I required a formula in "comparative" sheet.
my question is in the Yellow filled box. I have insert comment there. So please help me in this problem. I gave you some overview of my problem that i required a value after match three Columns.

with regards
Paramveer Singh
 

Attachments

  • question file.xlsx
    57.6 KB · Views: 15
The main issue is your data layout, if you are ready to manage data as per expert suggestions then it will too good for u as afterwards you will have the liberty of more approach else wait till someone suggest something.

Hope u got my point.
 
Dear Narayan Sir,
My problem is solve in cell "I7, K7, M7 & 07"
But in cell reference "I10, I11,I12 and I28, I29 and I30
Please check it and solve the issue
 

Attachments

  • question file (2).xlsx
    62.9 KB · Views: 2
and also sir cell reference "I10, I11,I12 and I28, I29 and I30" rate match with the Name of work "F2" and "F20"
 
Hi ,

Sorry , but this was not present in your original file ; you have added this now.

You will have to go through the formulae and extend them to work with this.

Narayan
 
Dear Sir,

I know but i extend it, because i want to check with the other work according to my working environment. but sorry to say this formula not fill correct value. You are excel ninja, so please solve this problem
 
Sometimes people want to learn to fish, other times they want you to fish for them. I understand the latter, but don't condone it - especially when they keep moving the pond and hiding the bait :p
 
Davind Evans I also try to learn but still fail to accomplish with my working file.
If you help me than pls help. otherwise don't make fun of me
 
Davind Evans I also try to learn but still fail to accomplish with my working file.
If you help me than pls help. otherwise don't make fun of me

Just to be clear, I was not making "fun" of you - I was making an example of how you're not truly wanting to learn, merely wanting someone to give you the answer. @NARAYANK991 has given you a perfectly good answer - you have to learn to adapt the answer to the changes you made from the initial worksheet you provided.

And I understand that English may not be your first language - it happens to not be mine, but you'd better served by being a little more polite and not demanding someone solve your problem. ("some body solve my problem") @Deepak, also suggested that a major issue with you problem is related to the structure of your worksheet - I'd wager a pound to a penny that its based on a paper system which you're trying to "copy" into excel - it's not the best technique to pursue. You chose to ignore his suggestion.

@NARAYANK991 and @deeepak give very freely of their time to people around here - I have witnessed it for several years, but they're not *required* to answer everyone's questions. Like most people, they respond to kindness rather than demands.
 
Hi Paramveer ,

I am sure you will take away something from Evans' post.

I would like to add my own opinion , because you had addressed me through a private message.

I am not so much bothered by your language or tone or anything that you post ; I have earlier mentioned in another context , that my reasons for answering are only 2 :
  • I would like to help if I can
  • I would like to learn if I can
Whether they are in that order or not , I find it difficult to say ; sometimes it is so , sometimes it changes.

My only problem is that I answer only if I have the time ; if I do not have the time , I don't answer.

It was not always so ; in the initial years when I joined this forum , I would spend much more time , but now this has reduced. The fact that there are many more experts who are willing to pitch in and answer means that my not answering does not matter.

The only point that bothers me is when people post a question , get an answer , and then post another question which enlarges upon their original question.

If you knew the kind of help you needed , right at the start , why could you not post your complete requirement ? Look at this thread to understand the kind of effort people go to , in order to post their complete requirement :

http://chandoo.org/forum/threads/help-with-matching-a-result-to-the-optimal-partner.29021/

When I see a question like this , I appreciate the effort and thought that has gone into posting as complete and comprehensive a requirement as possible ; I may or may not answer it , but at least I know what I am getting into when I attempt to answer it.

On the other hand , when a simple question is posted , I invest some time and answer it , only to find that another question has been posted in the same thread ; generally it happens that if one member has answered a question , others do not give it much attention , unless it is interesting enough. So what happens is that now the member who answered the first question feels obligated to answer the extended question.

I have no problem in this , except that I may not be able to devote time to answering this extended question immediately ; if you are willing to wait , I will certainly answer it.

Please bear with me for a day , and I will upload the revised workbook.

Narayan
 
Yes Sir you are very kind people to solve the issue of many person.
and also correctly say that English is not my first language. I always use word please to solve my issue. Still if anyone hurt then i feel guilty @David Evans
 
Dear Sir,
@NARAYANK991 you are very kind to solve the issue of many user.
No problem bro, i will wait. when you have time solve the issue.

with regards
Paramveer Singh
 
Back
Top