im familiar with vlookup in ms.excel but ive been trying for hours in lotus symphony
any ideas?
first i cant select the column, i had to choose the entire array from A1:B1048576.
i tried to limit my array to max 1000 rows (A1:B1000).
but it just doesnt work
Based on this file from IBM's Lotus support page (http://publib.boulder.ibm.com/infoce.../04060109.html ), the Lotus VLOOKUP function appears to operate exactly the same as Excel's VLOOKUP function. Their example function shows a lookup array limited to 100 rows, so I see nothing in this that would suggest that Lotus demands full column references. I expect there is something else going on. You might want to find a Lotus support community and see if they can explain the behavior you are seeing.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks