Thread: Lookup
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Lookup

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