Can't figure out correct lookup formula to look at a range in reverse (left to right)

[ZMAFC94]

Hi thanks for looking into this thread

I have had help putting together a VLOOKUP which looks at a range, right to left, col 1, 2, 3 etc.

But attached is a situation, where i do not know how to return a result which is located in a column on the left of the lookup value in a range. I'm not allowed to move any data in the 'lookup' tab hence why I'm looking for a way of having the vlookup look 'backwards'? I've been told its possible but not sure how.

'Sack Counts' has A3 highlighted yellow, "A Code" is the column which i'm trying to get the vlookup, to look up and return "VV Stock code" and "Description" in the 'Lookup' Tab. I've put in row 3 what I'm expecting.

Hope this makes sense
Would be gold if i could get some help on this
thanks

Z

[Sam Capricci]

you use index/match for that, try this... =INDEX('Look up'!B:B,MATCH('Sack Counts'!A3,'Look up'!E:E,0))

[KOKOSEK]

Into B3:

Please Login or Register  to view this content.

Into C3:

Please Login or Register  to view this content.

[Glenn Kennedy]

In B3, use:

=IFERROR(INDEX('Look up'!$F$4:$F$30,MATCH($A3,'Look up'!$E$4:$E$30,0)),"")

and a similar formula in C3...