Trying to return value based on lookup in table

1. Read rules
2. Change title according to the rules
3. Upload example workbook

TY

Sorry, I will change the title etc. now

Now available for your viewing

One more question. What do you mean by closes match?

For example:

21 between 20,00% and 22,50% is:
a) 20,00 because 21 is closer to 20 than 22,5
b) 22,5 because it's rounded up to higher value

Always closest value.
- 21 goes to 20% as it is closer.
- 21.9 goes to 22.5% as it is closer
The only occasion you round up is when it is EXACTLY in the middle.

Check this:

But for first value, maybe it's easier with this way (without table):

=L12/L15*L8 for exact value

=MROUND(L12, 0.025)/L15*L8 for rounded value and your desired result)

The 22% and 10% will change hence why I needed the tables to be searched based on what is in those cells.

Many thanks for the help all!

Here, I've made you example...

Now, depedning of how much you need precise your number I think first value is perfect while 2nd value is within 99% (and it could be 100 but with complicated formula... For smaller Company's ROE difference is bigger)

I've understood that values will change and that you need to search table... But it can be done without table... Just check red cells.