Can you please give me an example of how the formula woul look like?
i dont think i could use a dropdown menu beacuse this is for a Data Feed
4000 + products and i can't do them one by one.

So im looking for a formula in conjuction with VLOOKUP that would do that
form me.

again ie.

a range

..60-2.5 3.5
23-27 26.5
etc....


"Pete_UK" wrote:

Don't assume that other people have read your earlier posts.

It strikes me that a Data Validation drop-down in conjunction with
VLOOKUP would enable you achieve what you want. Set up a table
somewhere with the FULL range and the number it gets converted into,
and then you could set your DV drop-down to point to the first column
of your table and use VLOOKUP to return the second column.

Hope this helps.

Pete

On Nov 25, 7:46 pm, Gmata wrote:
Ok so i got the first part on how to use the VLOOKUP formula thanks to Alan,
now how about adding a range in there how could i do that.
for example:
i type i get
.1 to 1.50 2.95
23 to 25 40.0

Thanks