Maybe...

=LOOKUP(5,NumberRange,HeaderRange)

DBYRON wrote:
> If any one can help with this query would be much apprieciated i'm very in
> need of it thanks;
>
> Simple example of what i need; on my work sheet i have a row with monthly
> interest rates in as column headers i.e 0.3 0.5 0.7 0.8 as under each header
> is a figure i.e under 0.3 is 5 under 0.5 is 10 ect.
>
> I have a formula which gives me a figure under the colounm header so say my
> formula through out 5 i need to display in a cell the column header so 0.3.
> So i need something that says IF cell=5 display 0.3 OR IF cell=10 display 0.5
> OR IF cell=x display y.
>
> Your help really appriecited thank you.
>
> Dave
>