|
|
#4
08-29-2012, 11:27 PM
|
||||
|
||||
Firstly, your the range named Divisions is not defined.
Select col E and F and type "Divisions" (no quotes) in the space left of the formula bar Quote:
Is that what you want need ? If so, try Code:
=INDEX($E$2:$E$200,MATCH(A2,$F$2:$F$200,0),0)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Vlookup
|
ibrahimaa | Excel | 5 | 03-04-2012 11:24 AM |
| Vlookup | ibrahimaa | Excel | 8 | 01-03-2012 09:32 PM |
| Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |
|
Can i do this with a VLookup?
|
foodstudent | Excel | 1 | 01-21-2011 12:34 AM |
| Using IF & VLOOKUP together | junction | Excel | 7 | 11-18-2010 05:15 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode