Hey guys, I’m having some real trouble trying to figure out how to do a conditional lookup.
As you can see in the image, I have two tables and one select list. What I want to achieve is an automatic fill of the item store and price, based on the ‘preferred store’ that was selected. That part I have managed to do,
However, what I am trying to achieve is…
1- Have the user select the preferred store where they want to purchase items from.
2- Items inside of Shopping List will then be looked-up in Item List.
3- Inside Shopping List, the Store column will be filled in automatically based on the preferred store.
4- Inside Shopping List, the Price column will be filled in automatically based on the preferred store.
5- CRITICAL: If the item inside [Shopping List].Item does NOT have a corresponding item inside [Shopping List] that matches the preferred store, it should automatically DEFAULT to ‘store A’, as if that was the original store selected from the start. In other words, if the preferred store doesn’t have the item, display the data from ‘store A’ (because that store will always have it).
Hope my explanation is clear, if not do let me know. Any help would be greatly appreciated since I have tried multiple things, like IF, IFBLANK, etc, to no avail