vlookups

nuozek · Mar 19th, 2002, 08:04 AM

Hey there,
Urgh, im REALLY unsure about how to go asking this question! Basically what I want to do is make it so that when a checkbox is clicked it adds the price from a table to a cell I add the function to! I did everything correctly. However when I click my checkbox for it to add the price from my admin area of £99 all it does is say "true" (checked) ####(unchecked) in the cell link, im ALMOST certain my vlookup is right

perhaps someone knows where I am making a stupid mistake?

Thx alot
Nuozek

Tom Schreiner · Mar 19th, 2002, 12:47 PM

Are you using the CheckBox's value?
True 0r False?
The code to transfer your values should
be placed in the checkbox_change event...

Juan Pablo González · Mar 19th, 2002, 09:28 PM

That ##### means FALSE, but the column width is too small for you to see that.

Assuming this linked cell is A1, use this formula:

IF(A1,VLOOKUP(YourVlookUpFormulaHere),"")

Mar 19th, 2002, 09:28 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	That ##### means FALSE, but the column width is too small for you to see that. Assuming this linked cell is A1, use this formula: IF(A1,VLOOKUP(YourVlookUpFormulaHere),"") __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 08:04 AM	#1
nuozek New Member Join Date: Mar 2002 Posts: 16	Hey there, Urgh, im REALLY unsure about how to go asking this question! Basically what I want to do is make it so that when a checkbox is clicked it adds the price from a table to a cell I add the function to! I did everything correctly. However when I click my checkbox for it to add the price from my admin area of £99 all it does is say "true" (checked) ####(unchecked) in the cell link, im ALMOST certain my vlookup is right perhaps someone knows where I am making a stupid mistake? Thx alot Nuozek

Mar 19th, 2002, 12:47 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Are you using the CheckBox's value? True 0r False? The code to transfer your values should be placed in the checkbox_change event...