yogia,
Thanks, it works fine. For posterity purposes, I changed the type formula to be:
=LOOKUP(7,B2:G2,$B$1:$G$1)
where B2:G2 are the values for the current row, and $B$1:$G$1 are the type column headers.
but what is the significance of using 7 as the lookup value? Is it any numeric...