Could someone help me with an index and match function using vba? Right now in range AB6:AB16 (on sheet "Item 1") would be the index looking at sheet "lookups" range C4:C22 and range AC6:AC16 (on sheet "Item 1") would be the match looking at sheet "lookups" range D4:I4. And I would like to put the actual number value found in Range AE6:AE16 on Sheet 1

thanks in advance
excel 2010