Put simply I am trying to create a formula in TAB 1, that if I enter a 'Part
Number' in cell A1, Vlookup will return its description in cell A2 (no
problems so far), and then if I enter a quantity in A3, cell A4 will identify
the correct band from the following ranges ,25, 26-100, 101-500, 501-1000 or
1000 and return the correct unit price for the part number and quantity
break - which is identified and held in a separate table (on TAB 2),
alongside the Part Number and Descriptions.

Martin