IF statement?

[metalsped]

I am compiling a 'build sheet' for a few products. I have part numbers in one column, and prices in another (with checkmark boxes near product numbers). Im drawing a blank here, but I want to have the price appear in some box (have yet to determine, but I am going to put all the prices in a column, to make it easier to total). How would I go about linking the check box, to the price? Hope that makes sense. Thanks

[metalsped]

Here is a quick picture of what I tried to explain.

http://img.photobucket.com/albums/v5...sped/excel.jpg

The two columns on the right side I put in just to show the relation of part number to price. I just want to be able to check certain boxes, and have the costs line up somewhere, so I can total them at a later point. Thanks!

[MrShorty]

Here's how I think I'd do it:

1) Sort the price list alphebetically (necessary for VLOOKUP function to work correctly)
2) J4=IF("checkbox b4 is checked",VLOOKUP(A4,$O$3:$P$42,2),0)
3) K4=IF("checkbox d4 is checked",VLOOKUP(C4,$O$3:$P$42,2),0)
4) L4=IF("checkbox f4 is checked",VLOOKUP(E4,$o$3:$P$42,2),0)
5) M4=IF("checkbox h4 is checked",VLOOKUP(G4,$O$3:$P$42,2),0)
6) copy those formulas down as far as needed
7) H28=sum(j4:m21)

I'm not quite sure how you're supposed to check the checkbox -- seems like checked =TRUE, and not checked =FALSE, but I never use checkboxes, so I'm not sure.

You don't indicate a need to account for quantity of each item, that wouldn't be too hard to add.