Lookup

[Jack]

I have the following table sorted by Column A , B

A B C

1 apple $1.10 3%
2 apple $1.05 5%
3 apple $1.00 11%
4 orange $2.50 2%
5 orange $2.00 3%
6 orange $1.75 10%
7 orange $1.50 11%

For each item listed I would like to lookup the items based on column C
being Equal or < than a number (10%) and show the result from column B.

Result Example

Apple $1.05
Orange $1.75

 

[Don Guillett]

use data>filter>autofilter>filter on col C "less than"

 

[Jack]

I don't want all the values that are less then i just need the information
from the row with the value = or less than the number.

because of the large amount of date I was trying to do this on a summary page.

 

[מיכ×ל (מיקי) ×בידן]

Try this:
http://img294.imageshack.us/img294/5826/nonamee.png
Micky

 

[Jack]

thanks this worked great

Try this:
http://img294.imageshack.us/img294/5826/nonamee.png
Micky

 

[Don Guillett]

The archives can't see your file so please, in the future, post your
formulas in the body of a message.