Thread
:
Help with VLOOKUP formula
View Single Post
08-20-2012, 02:20 AM
Venky62
Windows 7 64bit
Office 2010 32bit
Advanced Beginner
Join Date: Jul 2012
Posts: 58
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.
Venky62
View Public Profile
Find all posts by Venky62