Referencing a textbox value from a determined value to a textbox range

Hi

This is my first time posting a query, but I truly am stuck on this one.

I am coding templated outlook emails from a userform.

I would like to type in a value in a textbox and then when I generate the email, I want a value from a different textbox dependent on the typed in value.

For example:
I have two Textbox's which say: 2-5 and 5-10. Next to these are another two textboxes which say £150 and £100 respectively.

I would like to have a 5th textbox that I can type a value in, say 3.5. This will then know that it falls in the 2-5 range and so when I generate the email it will input the textbox with £150 in to the template.

I hope I explained it clearly enough, but I'm not sure it is possible.

Any help would be greatly appreciated on this.

Thanks

Gareth

Are you coding the userform in outlook or excel? Can you please provide example of your current code?

Apologies let me rephrase my question, as I don't think I'm doing it correctly.

I'm coding on excel vba userform.

As an example:
On worksheet:-

A1 B1 C1 D1
0-5 £100 5-10 £150

On my userform I have a textbox. I want to enter a value in the textbox and for that to link to a cell on the worksheet dependent on range.

So, if I entered 3.5 then this would fall between 0-5 (A1) and so £100 (B1) will be linked.
If I entered 7.8 then this would fall between 5-10 (C1) and so £150 (D1) will be linked.

Is there any code I can use to activate this command on my userform?

I tried to put code in but I'm not allowed to show html coding, which is what I have used for the email template.

Have you tried creating a table and using vlookup instead? It will be easier for your textbox entry to find the value that way

0 100
1 100
2 100
3 100
4 100
5 100
6 150
7 150
8 150
9 150
10 150

Then use p = VLOOKUP(t, range, 2, false)

The problem with that code is it only refers to a fixed range. The range changes on different rows. So I need to reference a range typed in a cell. Not sure if it's possible.

Can you upload the file?

The prices also change from row to row.

so it may be like:
A B C D E F
0-5 £100 5-10 £150
2-5 £75 5-8 £100
0-5 £50 5-10 £100 10-15 £150

What is the identifier for the row you will use as your price reference?