MS EXCEL experts out there, I need help!!!!!

For example, the following is the original table:

From/To indicates the range for the "value"

Item From To Value
200000002 0.000 0.189 3423
200000002 0.189 0.830 3424
200000002 0.830 3.943 3433
200000002 3.943 4.393 865
200000002 4.393 5.607 3454
200000008 0.000 1.278 8889
200000008 1.278 5.432 5587
200000010 21.625 21.812 4564
200000010 21.812 22.468 4777
200000010 22.468 24.624 4556
200000012 27.068 41.089 6689
200000012 41.089 42.007 7688

I want correct values in the "Value" column in the following table:

Item Location Value
200000002 0.261 (the right value is 3424)
200000008 0.5 ???
200000008 3.698 ???
200000008 4.32 ???
200000008 15.396 ???
200000008 15.757 ???
200000008 16.417 ???

How do I get the right values in the "Value" column. I used VLOOKUP function of Excel but the problem is that VLOOKUP only looks at the first match in the "Item" field. How do I make it to look at the next row when the first match does not meet the criteria? I tried VBA/Macro but my knowledge is limited in these fields.

Helps will be appreciated.

no worries bro! i'm glad i was able to help!!! ah well that was little too much. anyways good luck with your studies!!!

Hey.. HYAAAAAAA bro!

is there a place where you can learn more about macro programming?

i use excel for 95% of work.. I have to all shots of thing in excel..
i have been going through online help and stuff to learn more about differnt functions and stuff..

i am good in java.. and have moderate programming skills in vb..

if you could share that .. this brother would be glad as my work would be lot easier...


some of the things i do are.. doing matchs.. getting file content from differnt system to analyze certain fields. (this is often hard.. coz every line has differnt format and I will have to work around a lot to use advance filter... )

any suggestions..??

007 bro,
if you know vb . . . that's it (forget java for a while)
Open Excel.
Press ALT + F11
Start coding.

I've got an ebook on that . . .

Programming Excel with VBA and .NET
By Steve Saunders, Jeff Webb
Publisher - O'Reilly

if you want it send me your email address (its about 9MB)

I use
"Excel 97 programming for dummies"
John walkenbach
ISBN 0-7645-0132-1

Life has been a lot easier.

I use VBA to send data back and forth between AutoCAD & Excel. Once you learn the basics, you can utilize codes available online to be tailored for your individual use.

yeo.. oz bro..
could you plz send me the book at bond17_007@hotmail.com

thanks,

i use excel help files. or msdn online.

Is there a single formula in cell B2 which can be copied across and down to create a multiplication table? (Hint: Think 'absolutely')

Here, eat this:

=row()*column()

copy everywhere.