PeteN69
New Member
Hi all,
Im trying to create a formula that will use a vlookup table based on a value but will change to another vlookup table when a few optional checkboxes are ticked.
Im sure i need a nested IF / AND / OR formula but i just cant seem to get the basic structure right to start with! I seen the few examples on the site, but i'm struggling to get the formula to work.
Any help will be greatly appreciated - I've attached an example to help describe what I'm trying to do.
Regards,
Pete.
Im trying to create a formula that will use a vlookup table based on a value but will change to another vlookup table when a few optional checkboxes are ticked.
Im sure i need a nested IF / AND / OR formula but i just cant seem to get the basic structure right to start with! I seen the few examples on the site, but i'm struggling to get the formula to work.
Any help will be greatly appreciated - I've attached an example to help describe what I'm trying to do.
Regards,
Pete.