I have this formula:

=INDEX('Sheet2'!BH2:BH94,MATCH(O2&T2,'Sheet2'!BF2: BF94&'Sheet2'!BG2:BG94,0))
(committed w/ Control Shift Enter)

and it works great.

However, when I try to put in absolute referencing I get a #N/A error

=INDEX('Sheet2'!$BH$2:$BH$94,MATCH(O2&T2,'Sheet2'! $BF$2:$BF$94&'Sheet2'!$BG$2:$BG$94,0))

Control Shift Enter will not even commit this formula to the cell.

What am I doing wrong .

Thanks

J