Finding Last Three Values From Dynamic Table Range in Excel

Hello All,

I'm trying to find a formula that is similar to a vlookup but where the formula will find values from the last three columns of a dynamic table. However, it can never pull in anything from column A. So if there are values in column B and C, it will only pull values in column B and C and not get a value from column A. Please let me know if there is a formula to achieve this. I've uploaded a sample workbook. Thank you for your help!

JLookupExample.xlsx