View Single Post
 
Old 08-20-2012, 02:20 AM
Venky62 Venky62 is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2012
Posts: 58
Venky62 is on a distinguished road
Default

The Index and Match formula in the Item column of the E1P sheet is an array formula, so after you paste it in the formula files, press Ctrl+Shift+Enter. Once you have entered the formula in once cell, you can drag it down to the rest of the cells.
Reply With Quote