Lookup
 

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

Lookup
 

use datafilterautofilterfilter on col C "less than"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack" wrote in message
...
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

Lookup
 

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.


"Don Guillett" wrote:

use datafilterautofilterfilter on col C "less than"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack" wrote in message
...
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

.

Lookup
 

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


"Jack" wrote:

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.


"Don Guillett" wrote:

use datafilterautofilterfilter on col C "less than"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack" wrote in message
...
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

.

Lookup
 

thanks this worked great

"מיכאל (מיקי) אבידן" wrote:

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


"Jack" wrote:

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.


"Don Guillett" wrote:

use datafilterautofilterfilter on col C "less than"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack" wrote in message
...
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

.

Lookup
 

The archives can't see your file so please, in the future, post your
formulas in the body of a message.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"מיכאל (מיקי) אבידן" <micky-a*at*tapuz.co.il wrote in message
...
Try this:
http://img294.imageshack.us/img294/5826/nonamee.png
Micky


"Jack" wrote:

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.


"Don Guillett" wrote:

use datafilterautofilterfilter on col C "less than"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack" wrote in message
...
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

.