MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
=IF(MATCH(O1,T1:T12,0)=1,INDEX(T1:T12,12,1),INDEX(T1:T12,MATCH(O1,T1:T12,0)-1,1))
Hlookup Example.xls | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | January | February | March | April | May | June | July | August | September | October | November | December | |||
Sheet1 |
=IF(MATCH(O1,B1:M1,0)=1,INDEX(B1:M1,1,12),INDEX(B1:M1,1,MATCH(O1,B1:M1,0)-1))
=IF(MATCH(O2,$B$1:$M$1,0)=1,INDEX($B$1:$M$1,1,12),INDEX($B$1:$M$1,1,MATCH(O2,$B$1:$M$1,0)-1))