Changing to tables so my 2007 work book will work in 2010.

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

Your file is a bit big - few people will be tempted to download it. Shorten the file, and then re-submit it.

Pete

Thank you Peter, that is something I have learned to ignore for years now.

I am updating my workbook so it will work on Excel 2010 and I fixed that earlier today.

Long story but thanks so very much.

I also fixed all my drop down list to work and change all my formulas to find them.

Now I think I can upgrade to at lease 2010 without to many problems.

I do not know how to show this thread a solved but it is.

Yes Pete it is big but to much work to make it smaller sorry but my problem is fixed thanks anyway!!

Okay, if that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete