Struggling to find a solution for this.
I need to lookup a value in one column, if that value is false, then lookup using another column, if that is false then display a 0.
Have tried using ISNA, Nested Ifs etc.
So in the attached spreadsheet I need to use the values in f or g to lookup against a/b to display the order amount in H, or if its not in either display a 0.
Thanks for any help, sure this will be very easy for someone that knows!
Bookmarks