Thank you so much for trying!
I made an image to explain more clearly (hopefully).
Technically all of the data involved in this is numbers, but the use of both Value and Text in VLOOKUP is only because sometimes the cells get read properly and sometimes they don't (by Excel). I fix that by using both. This is not a problem and I get the correct results.
What I need help with now is that I want to add a second complete formula that multiples the Fee % found in the table times another cell value on the same row.
I have about 5000 rows of data for this project, in case that matters.
Hopefully this helps!
|