Help with Vlookup - Storing several values on a variable

[Dedes]

Hi,

I have attached to this post a file explaining my goal:

On cell B5 we enter a % and based on the table I have made, I get a price on cell B8.

This is a simple and classic example on how the Vlookup function works.

What I wanted to know how to do is, how to do all this in VBA. The only thing that would be on the worksheet would be the cell B5 asking for the % - the price value would be recorded on a vairable to be used on a diferent calculation.

So,how do I create on VBA that table? And how I use the vlookup function to search?

I am used to programme in R. In R I would create an object with all my table values. Then I would create my querry asking it to search the value I want on the object containing the table. How is this done in VBA?

thanks
Dedes