ExcelBanter - View Single Post

Dolores Gomez[_2_]

Thanks, this really helped

"Luke M" wrote:

Break the range up into two columns (Data - Text to columns). Assuming you
don't have gaps/overlaps in your price range (why would you?) your formula
can then become something like:
=LOOKUP(Value_to_find,A2:A10,C2:C10)

--
Best Regards,

Luke M
"Dolores Gomez" <Dolores wrote in message
...
I am trying to assign codes to one of my worksheets based on pricing. The
problem that I am running into is that the data that I am taking my
information has a range of pricing Example below

PRICE POINT/RANGE PP
$0.01 TO $1 PP0100

I need to have a formula that looks at "PRICE POINT/RANGE" and compare it
to
a column that has pricing (i.e .95). This formula/function should give me
the "PP" code.

.