Find Value Between 2 column Range Excel Macro [Solved/Closed]

Jenz - Sep 17, 2010 at 09:33 AM - Latest reply:  Jenz
- Sep 19, 2010 at 08:05 PM
Hello,

I have a 2 Columns of Data (A) and (B) that provides me with a specific range, and a third column C that provides a corresponding value for that range. Next I have a column D that provides me with a value i have to match within the specified column range A and B to produce Column E. Can I be get some help with a sample Looping code for a macro that can help me generate a sample of column E, assuming that the inputs of A to D could be a variable?

For Eg.

A B C D E(Display Column)
3 4.0 2.1 4.5 3.2
4.1 7.0 3.2 5.3 3.2
7.1 10.0 4.3 3.6 2.1
10.1 11.0 5.5 10.9 5.5


See more 

3 replies

rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Sep 19, 2010 at 06:20 AM
0
Thank you
You data and you example image does not seem to be same.. Based on your example, you can use

=VLOOKUP(E1,A:C,3)
-1
Thank you
I have found my answer already thanks for the help. XD