VLOOKUP FUNCTION (pt 2)

Posted by Chuck L. on February 05, 2001 12:00 PM

Thanks! Well, Im now getting an N/A response so I guess Im close(er). Since Im really running out of time on this one heres what I have.

My formula is in column 15 of Worksheet 1 of the spreadsheet. I want to match the data that is in column 3, and the data in column 13 (all on the same row). The information that I want is on Worksheet 2 column 6 of the same spreadsheet. The matching data in Worksheet 2 is in columns 2 and 5 (ref: worksheet 1 columns 3 & 13)

I never quite got there with this formula, did I?

=INDEX(PP!$B$2:$F$300,MATCH(C2&M2,$B$2:$F$300,0))

THANKS, and THANKS AGAIN

Posted by cpod on February 05, 2001 2:15 PM

If I understood what you want, try this:

={SUM(((Sheet2!$B$1:$B$20=Sheet1!C1)*(Sheet2!$E$1:$E$20=Sheet1!M1))*Sheet2!$F$1:$F$20)}

this is an array function.

Posted by Celia on February 05, 2001 4:12 PM

=INDEX(Sheet2!$F$2:$F$300,MATCH(C2&M2,Sheet2!$B$2:$B$300&Sheet2!$E$2:$E$300,0))

Enter with Ctrl+Shift+Enter