| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hardcore formula heroes - Combination Vlookup and multiple IF form
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula help - possible vlookup/hlookup combination with IF or oth | Excel Worksheet Functions | |||
| Please Help!! Vlookup and combination formula | Excel Worksheet Functions | |||
| Formula help: VLOOKUP in a combination... | Excel Discussion (Misc queries) | |||
| Combination of H & Vlookup?? | Excel Worksheet Functions | |||
| "combination drop-down edit " form activation in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
