IF statement?
 

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
------------------------------------------------------------------------
metalsped's Profile: http://www.excelforum.com/member.php...o&userid=22824
View this thread: http://www.excelforum.com/showthread...hreadid=377461

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!


--
metalsped
------------------------------------------------------------------------
metalsped's Profile: http://www.excelforum.com/member.php...o&userid=22824
View this thread: http://www.excelforum.com/showthread...hreadid=377461

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.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=377461