Lookup
"Reen" wrote in message
...
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<A139,LOOKUP(function here),"")
Or similar - I'm a bit rusty!
HTH
|