# VLookup Table Help

#### 4petessake

##### New Member
Hi everyone, I am working on a spreadsheet and have three columns in my lookup table

ROA 1 ROA2 Percentage
2.00 2.50 115%
etc etc etc

How do I write a formula to say if roa1 is between 2.00 and 2.50, then percentage equal 115%?

TIA

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Is the table large?

If not, perhaps show the whole table and someone can guide you to the best formula to suit your needs.

4petessake said:
Hi everyone, I am working on a spreadsheet and have three columns in my lookup table

ROA 1 ROA2 Percentage
2.00 2.50 115%
etc etc etc

How do I write a formula to say if roa1 is between 2.00 and 2.50, then percentage equal 115%?

TIA

Default to True for an approximate match in a VLOOKUP formula.

=VLOOKUP(E1,A2:C10,3)

Where E1 houses a value

Replies
5
Views
83
Replies
3
Views
174
Replies
2
Views
140
Replies
2
Views
131
Replies
0
Views
271

1,203,329
Messages
6,054,756
Members
444,748
Latest member
knowak87

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back