Need to select a value from a given range (XL

Closed
praf - Sep 15, 2008 at 04:31 AM
andy6776 Posts 17 Registration date Sunday August 17, 2008 Status Member Last seen January 13, 2009 - Sep 15, 2008 at 06:56 AM
Hello,

I have a database which has huge values from 10 to 1M.
I want to create a database if someone inputs a value which is not in the database. It gives values to the nearest number. is it possbile in microsoft excel. Am using 2000.
Please advice

1 response

andy6776 Posts 17 Registration date Sunday August 17, 2008 Status Member Last seen January 13, 2009 23
Sep 15, 2008 at 06:56 AM
hey there,

i dont think it possible in excel unfortunately. why dont you use visual basic for these kind of programming instead?
0