Approximate match lookup for the last cell requires high lookup value, "z" > "x"
=MATCH("z",I4:X4) can find last cell at 13
while Match "x" may not return last cell
=MATCH("x",I4:X4)
Approximate match lookup for the last cell requires high lookup value, "z" > "x"
=MATCH("z",I4:X4) can find last cell at 13
while Match "x" may not return last cell
=MATCH("x",I4:X4)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks