Comparing two Columns and pulling data from a third

[Athirst5IoN]

I am working with two sheets. One named RawData where I have imported data, and the main page I am using to work with the data.
I am trying to fill a column on the main page by comparing data in two columns and pulling over data from a corresponding third column. For example:

(Main)
Product Version Owner
a 1
b 3
c 4

(RawData)
id Product Owner Version
321 a john 2
516 a tim 1
123 b alex 3
984 c matt 2
195 b john 6
865 c alex 4

~ keep in mind there is much more info than this, but im just making a few simple columns for the example.

I want the cells in Main column C to be filled with the correct persons name that is in the same row as the correct Product and Version. Keep in mind I cannot just simply make a cell equal to another cell since the RawData sheet has thousands of rows of data. This is what I have so far:

=INDEX(RawData!C:C,MATCH(1,(A2=RawData!B:B)*(B2=RawData!D:D),0))

I'm fairly new at working with formulas and queries in excel. Could anyone help me with this?

Thanks in advance

 

[Athirst5IoN]

I tried to make an example of the rows and columns but it seems to not take spaces and tabs into account once I post.

 

[Trouttrap2]

Try this: just change the ranges for your data. It might run slow if you choose the whole column as your ranges.

=INDEX(RawData!$C$2:$C$7,MATCH(MainPage!A2&MainPage!B2,RawData!$B$2:$B$7&RawData!$D$2:$D$7,0))

then enter the formula with CTRL+SHIFT+ENTER, not just enter since it's an array formula.

 

[Athirst5IoN]

Thanks, but I'm still getting #N/A for everything . Any other ideas?

 

[Athirst5IoN]

bump

Can anyone help?

 

[Haseeb Avarakkan]

Try,

=INDEX(RawData!$C$2:$C$1000,MATCH(1,IF(RawData!$B$2:$B$1000=$A2,IF(RawData!$D$2:$D$1000=$B2,1)),0))

Confirmed with CTRL+SHIFT+ENTER, not just ENTER.

$A2=Product
$B2=Version

Or,

=LOOKUP(2,(RawData!$B$2:$B$100=A2)/(RawData!$D$2:$D$100=B2),RawData!$C$2:$C$100)

 

[Trouttrap2]

Can you show what formula you are using?

Did you CTRL+SHFT+ENTER? it will have curly brackets {} around the formula.

The formula I sent works for me. You can try this one: same as before just a larger range.

=INDEX(RawData!$C$2:$C$65536,MATCH(MainPage!A2&MainPage!B2,RawData!$B$2:$B$65536&RawData!$D$2:$D$65536,0))

 

[Trouttrap2]

I think I might see the problem confirm the worksheet names inthe formula. Are they "RawData" and "MainPage" or is it "Main" page. If that is it just rename the worksheet reference in the formula.

=INDEX(RawData!$C$2:$C$65536,MATCH(Main!A2&MainPage!B2,RawData!$B$2:$B$65536&RawData!$D$2:$D$65536,0))

 

[Athirst5IoN]

This is what I was using and yes I'm using CTRL+SHFT+ENTER:

=INDEX(RawData!$N$2:$N$39697,MATCH(1,(B10=RawData!$H$2:$H$39697)*(E10=RawData!$L$2:$L$39697),0))

I tried the more recent formula and is actually pulling data, but not the correct data.

=INDEX(RawData!$N$2:$N$39697,MATCH(PR9C!B27&PR9C!E27,RawData!$H$2:$H$39697&RawData!$L$2:$L$39697),0)

PR9C is the name of my main page. The forumula above is pulling information from the correct column (RawData column N), but it is pulling data that does not correspond with the Match. So i'm currently trying to figure out why that is.