How about an HLOOKUP formula?:
where A1:C1 contain "north, south, west", D1=direction and E1=row
number; place in F1:

=HLOOKUP(D1,A1:C50,E1+1,0)

(note the formula adds 1 to row value E1, as HLOOKUP counts the Header
as row 1, so if you want the first value in the table, enter 1, the
formula adds 1 to give you the 2nd row in the table)

of course, adjust ranges to meet your needs.

Good luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=481017