| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index and Match
PLEASE PLEASE PLEASE HELP!!
I want to create a formula to help with pricing. I have a list of data in columns: Model Number, Processor Number, Edition Number and CPW I have created a data validation list for the Model No, Processor No and Edition No so that these can be picked and need the CPW to automatically be input into the cell below for the prcing to be calculated. This is the formula I have done =INDEX((K5:M19,K24:M28),MATCH(R8,Model.,0),MATCH(R 10,Proc,0),MATCH(R12,Edition,0)) but it doesn't work!!! PLEASE HELP! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
Threaded Mode
