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