=INDEX(C33:C37,MATCH(TRUE,EXACT(J29,B33:B37),0)) <--- How did (TRUE,EXACT(J29,B33:B37) became 3 which then became =INDEX($C$33:$C$37,3)
Also,how did the dollar sign got there?
C33:C37
$0.115
$0.185
$0.245
$0.275
$0.435
J29 = West
B33:37
NW
WEST
West
MidWest
East
Bookmarks