MATCH the last instance of a value in a column

[MartinL]

If I use the formula

=MATCH(771160,Table1[Barcode],0)

the result will always stop at the first ROW that contains the matched value.

How can I find the last row that contains that value?

Ultimately I am doing a MATCH and INDEX to get an adjacent alphanumeric value.

Martin

 

[Firefly2012]

Hi

Try:

=LOOKUP(2,1/(Table1[Barcode]=771160),ROW(Table1[Barcode]))

I
ve never used this with a Table before though so not sure if it will work

 

[taurean]

This works in Non Table range.
=LOOKUP(99999,SEARCH(C1,A1:A7,1),ROW(A1:A7))
Which should translate & hopefully work as:
=LOOKUP(99999,SEARCH(C1,Table1[Barcode],1),ROW(Table1[Barcode]))

 

[MartinL]

Firefly,
Your answer works just fine, many thanks

Taurean - I'm just looking at your now

 

[MartinL]

taurean,
I can confirm your answer works just fine too, many thanks