I am building a report and I have several checks I need the formula to do;
1st - Look up code and if matching then = zero,
2nd - If the code doesnt match then look up a second code in a list a if found then = Zero
3rd - If neither of the above is true then multiply by X.
I have added an example to make it more clear, I had thought of using the 'IF' formula but this may not be the best. I have made an attempt to show mu thinking in the cell highlighted in yellow.
Any help is appreciated.
Thanks
Bookmarks