Lookup:cell next

[Reen]

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

[Gordon]

"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

[CLR]

Your post does not contain enough information to give a specific solution,
but you might consider something like this....

=VLOOKUP(A1,G1:H10,2,FALSE)

This will lookup the value in cell A1 in the range G1:G10, and return the
adjacent value in column H if it finds a match. The cell and ranges can be
adjusted to suit your requirements.

If you need more help, then please post back with more details..........

hth
Vaya con Dios,
Chuck, CABGx3



"Reen" wrote:

> 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