Vlookup For Furthest Right Column?

Hi Guys-

My data is loaded in a preset order on about 20 different workbooks, so switching the data manually would be a pain.

I have a reference number that will occur in the furthest right column (Q). I just want to return the G column's value when the Q column = the reference number.

Is there a vlookup that would look at the furthest right column instead of the furthest left?

Thanks!

That worked perfectly. Thanks!