Look up from Right Hand Column?

**groitblat** · 10-09-2014, 12:58 PM

Everything I read says vlookup and index/match has to work from right to left.
I have the attached sheet where I want to pull out Data from Column J & Column U for when the Status column first becomes #1....

I can't seem to reverse logic my basic lookup skills to do this? Or maybe I have to just reformat the output to have status in column 1? Sort of hate to do that cuz I'm feeding a lot of info off of the current Data in Column A

Any help is appreciated

Thank you

**TMS** · 10-09-2014, 01:03 PM

Formula:

Please Login or Register  to view this content.

Regards, TMS

**canapone** · 10-09-2014, 01:19 PM

Hi,

a possible, not practical approach using vlookup could be

=VLOOKUP(1,CHOOSE({1,2},Y3:Y17,J3:J17),2,0)

=VLOOKUP(1,CHOOSE({1,2},Y3:Y17,U3:U17),2,0)

Regards