So I have a spreadsheet where I have a list of order IDs, and shipping prices to be looked up per the order ID. My problem is that there are three columns of shipping costs on another worksheet (range "shippingcharges"). Only one column has the shipping charges and the other 2 will have 0 entered into it.

IF shippingcharges column 7 =0 THEN LOOKUP 8 and so forth through all three columns.

Below is what I have written to this point (for 2 columns) and it works as long as the shipping charges are on the first column. If the first column is 0 then I get nothing.

=IF(VLOOKUP(A9,shippingcharges,9,FALSE),0,VLOOKUP(A9,shippingcharges,8,FALSE))

It appears as if it is not doing the IF and just doing the VLOOKUP.

If I have not explained it clearly, I will try one other way.

VLOOKUP checks A1 for OrderID and Vlookup's the OrderID in range "shippingcharges" (which has 9 columns, last 3 of which are costs).

IF the seventh column of shipping costs = 0 then return costs in column eight, If the costs =0 then return costs from the ninth column.

This has GOT to be an easy one but I am losing it and cannot see it.