![]() |
|
#1
|
||||
|
||||
![]()
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 | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
foodstudent | Excel | 1 | 01-21-2011 12:34 AM |
Using IF & VLOOKUP together | junction | Excel | 7 | 11-18-2010 05:15 AM |