Skip to Content
0
Former Member
Feb 01, 2010 at 11:22 AM

MATCH function support

36 Views

Hi

I am having problems with the match function

Basically I am using it to find the first and last position of a value in a range.

=MATCH(B1,D5:D30,0)

works fine to return the first value, but

=MATCH(B1,D5:D30,1)

to find the last value only works in the spreadsheet, not in the SWF.

Anyone got any ideas?