That should probably be

=INDEX(Sheet_2!$C$1:$C$100,MATCH(A1&"2",(Sheet_2!$ A$1:$A$100&Sheet_2!$B$1:$B
$100),0))

--
HTH

Bob Phillips

"Ola" wrote in message
...
Try this Array formula:

=INDEX($C$1:$C$100,MATCH(A1&"2",(Sheet_2!$A$1:$A$1 00&Sheet_2!$B$1:$B$100),0)
)

Ola Sandstrom

Note:
Confirm the formula by holding down Ctrl and Shift, and then press Enter.
Othervise the result will be #VALUE!
If there is no match the formula will return #N/A. Then use
IF(ISERROR(...),"",...)