LOOKUP (B69,$a$4:$B$24,$C$4:$C$24)*B77 returns err 504
If I change $A$4:$B$24 to $A$4:$A$24 it no longer returns err 504
LOOKUP (B69,$a$ 4:$B$24, $C$4:$C$ 24)*B77 returns err 504
If I change $A$4:$B$24 to $A$4:$A$24 it no longer returns err 504