VLookup multiple columns?

[cheflauren34]

On one sheet I have a column of participant numbers (80 rows per participant), the text they saw during the experiment (80 different pieces of text), and the rating they gave each piece of text (a number betwen 1 and 7).

On the second sheet, I have the same participant numbers, and the same pieces of text, only in different order. I want to create a formula that say "Ok, this is participant 402, with the text 'X-rays are covered', and they rated that a 5, so I'm going to put a 5 in my cell"

I tried an IF statement nexted in VLOOKUP, and it worked for the first participant (80 lines), but when we got to a different participant, it just kept entering the ratings from the first participant.

Any help would be appreciated!
Thanks!

[jasoncw]

It sounds like you need Sumproduct, rather than Vlookup. You can read how to use it here:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

HTH

Jason

[cheflauren34]

Thanks! I actually got it to work myself (with a little help from someone else )

=IF(B15=[alldata.xls]Importance_Old!$B15,VLOOKUP(L15,[alldata.xls]Importance_Old!$F15:$G$1441,2,FALSE),FALSE)