Comment 3 for bug 381543

Revision history for this message
Kieran Fleming (kieran-fleming) wrote : Re: OpenOffice Calc VLOOKUP function doesn't work like Excel

Well, I don't really want to get into the question of who is following the spec the closest, because we all know that MS and specs don't mix :)
I can't see a big problem with accepting a single value in this function, and it would help compatibility with Excel, which is good for users. I should also point out that I found this bug trying to edit my timesheet at work, so this is a problem that happens in the real world. Also, Gnumeric doesn't have this problem, so making this change wouldn't affect compatibility with that.