Lookup

  • Thread starter Thread starter Jack
  • Start date Start date
J

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
 
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.
 
The archives can't see your file so please, in the future, post your
formulas in the body of a message.
 
Back
Top