MS Works Spreadsheet 2000 v5.0 VLOOKUP

[John L.]

My VLOOKUP does not appear to work correctly. Given the following:

AI AJ VLOOKUP("Chores",AI2:AI6,0) => "Chores"
as expected
2 "Chores 8 but VLOOKUP("Chores",AI2:AI6,1) => ERR
3 "Fun 4
4 "Sleep 8
5 "Meals 2.5
6 "Service 3.0

Any insight or advice would be appreciated.
(By the way, this VLOOKUP only takes 3 parameters.)

 

[garfield-n-odie]

You might try VLOOKUP("Chores",AI2:AJ6,1) or ask in the Works
newsgroup at
http://www.microsoft.com/communitie...x?dg=microsoft.public.works.win&lang=en&cr=US
..