• 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.

Pull Data with help of Formula

A

Abhijeet

Active Member
Hi

I have Data i want pull result in Main data sheet i have highlighted in Green color with result please tell me how to do this with help of formula
 

Attachments

=INDEX('Refer Sheet'!$C$2:$C$15,MATCH('Main Data'!$A3,'Refer Sheet'!$A$2:$A$15,0),MATCH('Main Data'!C$1,'Refer Sheet'!$B$2:$B$15,0))
 
You can use ARRAY formula (it needs to be CTRL+SHIFT+ENTERed) in C3 which should be copied down and across:
=IFERROR(INDEX('Refer Sheet'!$C$1:$C$15,MATCH('Main Data'!$A3&'Main Data'!C$1,'Refer Sheet'!$A$1:$A$15&'Refer Sheet'!$B$1:$B$15,0)),"")
 
Hi Abhijeet ,

If you know your data is huge , why do you not mention this in the thread , right at the beginning ?

Anyone who posts a problem should describe all the constraints right at the outset , not after members have spent time on coming up with a solution.

1. Are helper cells / rows / columns acceptable ?

2. Are array formulas acceptable ?

3. Is VBA acceptable ?

These are the basics which anyone who posts should mention ; respect those who volunteer their time and effort in finding solutions to problems that are not theirs.

Narayan
 
every thing is acceptable but when any one is learn then that person is looking at what is not know
I know Index + Match so i am looking any other way is their
 
Hi Abhijeet ,

This forum has a limited number of volunteers who answer questions ; I am fairly sure that a lot of people who post their questions / problems are having issues at work which they would like to resolve , generally in a limited time-frame ; these issues may be in the office or at school or anywhere else.

Not many people post questions just so that they can learn ; surely this learning can be done by going through tutorials , blog posts and articles that are there in plenty on the net.

The time spent in answering your question , which you are asking only to learn , can be spent probably more profitably in solving someone else's problem , which may be of far more importance to them , than this learning is to you.

I am not saying that academic questions should never be asked , but to expect that such questions will be answered on a priority basis is not correct ; expect to wait till someone finds the time to answer your question.

And in the meantime , take the time and effort to find an answer to your question on your own.

Narayan
 
Hi:

Here are couple of non-array formulas.

Code: 
=IFERROR(INDEX('Refer Sheet'!$C$2:$C$15,MATCH(1,MMULT(($A3='Refer Sheet'!$A$2:$A$15)*(C$1='Refer Sheet'!$B$2:$B$15),1),0)),"")
Code: 
=IFERROR(LOOKUP(2,1/(($A3='Refer Sheet'!$A$2:$A$15)*(C$1='Refer Sheet'!$B$2:$B$15)),'Refer Sheet'!$C$2:$C$15),"")

Thanks
 
You must log in or register to reply here.
Back
Top