=INDEX(Sheet1!$C$2:$C$6,MATCH(B2&C2,Sheet1!$A$2:$A $6&Sheet1!$B$2:$B$6,0))
entered while holding down the Ctrl and Shift keys works fine for me.

"Deborah" wrote:

The ctrl-shift-enter does not seem to work... Is there any other way?

Thanks

"Duke Carey" wrote:

2 things:

1) You need to enter it with Ctrl-Shift-Enter
2) drop the ",3" at the end of the formula

"Deborah" wrote:

Sheet 1 has 3 columns: grade, step, NBS
Sheet 2 has 3 columns: SM, grade, step
I want to add a column NBS to sheet 2 for that exact grade and step, from
the data on sheet 1.

I tried the following formula but it gives me #value!.

=INDEX(sheet1!$C$2:$C$6,MATCH(B2&C2,sheet1!$A$2:$A $6&sheet1!$B$2:$B$6,0),3)

Thanks for your help

Deborah