Thread: Index and Match
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alia Alia is offline
external usenet poster
 
Posts: 2
Default 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!