VLookup Table Help

[4petessake]

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

 

[NBVC]

Is the table large?

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

 

[Brian from Maui]

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