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.
Attachments

24.2 KB Views: 9