"Reen" <Reen@discussions.microsoft.com> wrote in message
news:F1749FE5-79BD-4C36-BB4D-EA77A1E52603@microsoft.com...
>I am trying to use the look up function and not succeeding!! What I need
>is
> when a percentage between 0 to 39 is in a specific cell I need the cell
> next
> to it to look at a group of cells in another area and pull the
> corresponding
> cell. I hope this makes sense!!!
> Thanks


You need to combine an IF statement with a LOOKUP statement as in:
In B1 type IF(0<A1>39,LOOKUP(function here),"")
Or similar - I'm a bit rusty!

HTH