I have an inventory spreadsheet that contains two columns that use VLOOKUP to find a discount multiplier. One column contains standard discount multipliers and the other special negotiated multipliers that only apply to certain items. Some of the items in the special negotiated multipliers contain #N/A because they only have a standard discount.
I want to add a column that will compare the two columns and take the lower multiplier but only when there is values in each column. If the special discount column contains #N/A it should show the standard discount.
How can I do that?