Using data validation to vlookup and tried to replace this =IF(B23>0,VLOOKUP(B23,Data!$A$1164:$B$1365,2,0),0) with
=IF(B22>0,VLOOKUP(B22,MATERIALS[[#Headers],[MATERIALS]],2,0),0)

this is the table it is looking at

MATERIALS CATEGORY PRICE
18 Stakes $0.34
24 Stakes $0.35
30 Stakes $0.40
36 Stakes $0.45
40 Stakes $0.72
2001 Concrete $82.50
2003 Concrete $102.50
2501 Concrete $85.00
2503 Concrete $105.00
3001 Concrete $87.50
3003 Concrete $107.50
3501 Concrete $90.00
3503 Concrete $110.00
4001 Concrete $92.50
4003 Concrete $112.50
4501 Concrete $95.00
4503 Concrete $115.00
3/4" Gravel Gravel $26.00
Pea Gravel Pea Gravel $26.00


Is my table made incorrectly maybe???


Will attach file