%percentage and Vlookup

Dear Guru,
Please find attachment how to use any function after I calucualte % achieve and to match in table and show rate in column B how to user function to return value same in table Rate?

after I create %ratio and can't vlookup due to not same value.
Please help.
Thanks.