Dear KK,

Excel accepted the formula you listed below but I get a #N/A. Any possible
problems I can research? What does the 0)-1,3 at the end of the function
mean?

thanks for the help
SL

"kk" wrote:

=INDEX([WVE1_passwords2.xls]WVE1_USERS!$A$1:$C$424,MATCH(A7,[WVE1_passwords2.xls]WVE1_USERS!$A$1:$A$424,0)+MATCH(B7,[WVE1_passwords2.xls]WVE1_USERS!$B$1:$B$424,0)-1,3)


"SL" wrote in message
...
Malik641:

I tried this:
=INDEX([WVE1_passwords2.xls]WVE1_USERS!$A$1:$C$424,MATCH(A7,[WVE1_passwords2.xls]WVE1_USERS!$A$1:$A$424,0)+MATCH(B7,[WVE1_passwords2.xls]WVE1_USERS!$B$1:$B$424,0))-13

got an #N/A error--what does that mean? It would not allow me to end my
function in -1,3) like you suggested. It changed it to -13???

the wve1_passwords2 is the lookup table with the lastname (A), firstname
(B), and student ids (C) in it. and the wve1_users is the sheet name.

Thanks for all your help. Any other ideas?? I know it is close but I am
just missing something maybe syntax?

shaunna

"malik641" wrote:


Here's one way, though it's not the best:

=INDEX(Sheet1!A1:C10,MATCH(A1,Sheet1!A1:A10,0)+MAT CH(B1,Sheet1!B1:B10,0)-1,3)

In sheet one:
Last names are in column A
First names are in column B
Student numbers are in column C

In sheet2:
Last name is in A1
First name is in B1
Formula is in C1


...Still working on it. But let me know how that one works for ya.


--
malik641


------------------------------------------------------------------------
malik641's Profile:
http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=468318