IF Function with Lookup from Right to Left

I am trying to lookup a value from one sheet to another, ensure that a certain criteria of the matched value is met (using the IF function) and hence I want my return value to be from the same row, a few columns to the left.

Formula I am using:

=IF(vlookup(lookup value, table array, column number, FALSE)="Accepted", return value from same row but 5 columns to the left)

I hope I made sense

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new, I have done it for you this time.)

Originally Posted by Pepe Le Mokko

Errrr, it can be used to look from right to left

Not natively - you have to add a CHOOSE function to make it work. INDEX MATCH can be used either way without a workaround.

No, just pointing out a fact.

Errrr, it can be used to look from right to left

This is somewhat misleading. VLOOKUP cannot do this natively. You have to add a CHOOSE function to do it (as I said above). Something like this:

=VLOOKUP(F2,CHOOSE({1,2},B2:B4,A2:A4),2,0)

See here for more on the technique: https://www.myonlinetraininghub.com/...t-using-choose