There will not be any blank cells and the order is ascending

Thanks--
Bambi


"driller" wrote:

Hi Bambi,

Assuming your orig. search price is in A1
and the 10 prices are in A2:J2
please inform IF
1. Any possibility that there will be blank cell (no price) within A2:J2 ? .
2. Are the 10 prices arranged in which order (ascending, random, descending) ?

regards
--
*****
birds of the same feather flock together..



"Bambi Williams" wrote:

I have 10 cells with different prices. I want to be able to automatically
calculate, and I am not sure of the formula that will allow me to do this. I
want the formula to automatically look at the list of prices and IF the price
is greater than the price in column A, then it will look in column B. It it
is not greater than column B, that price will be put in the cell with the
formula. If the price is not greater than column B, then it will move down
the remainding columns until it finds the price that is not greater than.
Any help with this would be GREATLY appreciated.
--
Thanks--
Bambi