IF statement?

[metalsped]

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

 

[metalsped]

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

http://img.photobucket.com/albums/v57/metalsped/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.