|
|
#1
03-09-2016, 09:14 AM
|
|||
|
|||
Can I substitute Vlookup with Index
Hi All,
I am trying to figure out if there is another formula rather than VLookup. When you select column “A” on tab Test will automatically populate column B and C, taking information from the tab “new”. To make the Vlookup works I hade to put in the first position the subcategory, changing the original layout. If I move subcategory in the 3rd column can I use another formula to populate the columns “Category” & “cost type” (I was thinking Index or Index match) but I am not very familiar with Index formula. Thanks Ale 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Substitute for Content Controls in Word 97 - 2003 Document
|
taryn | Word | 4 | 02-13-2015 01:30 PM |
|
Help with LEN and Substitute function
|
Natalee | Excel | 5 | 11-08-2014 07:56 AM |
|
Find & Replace: substitute red-coloured words with underscores
|
tinfanide | Word | 2 | 10-06-2012 11:04 PM |
| Match Index with sumproduct/vlookup | angie.chang | Excel | 1 | 06-18-2012 08:47 AM |
|
Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
Windows XP 
Office 2007
Threaded Mode