Todd,

You could use a VLOOKUP

=VLOOKUP("Test",E1:I10,5,FALSE)

OR

=INDEX(E1:I10,MATCH("Test",E1:E10,0),5)


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=556508