|
|
|
|
#1
08-20-2012, 02:20 AM
|
|||
|
|||
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.
|
|
| Tags |
| vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Using IF and VLOOKUP together
|
Becki | Excel | 2 | 04-06-2012 05:32 PM |
| something like VLOOKUP | hanvyj | Excel | 4 | 03-13-2012 09:03 AM |
|
Vlookup
|
ibrahimaa | Excel | 5 | 03-04-2012 11:24 AM |
| Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |
| Help with VLOOKUP | sakhtar | Excel | 2 | 07-24-2010 07:39 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode