vlookups

[nuozek]

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

 

[Legacy 98055]

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]

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),"")