J
JLIM
Does Vlookup work differently in Pocket Excel in
comparison to Excel 2003?
I am trying to get the following function working under
pocket excel:
VLOOKUP(CourseName,CourseTable,2,'Course Data'!B:B)
CourseName is a Name defined for an adjacent cell ie
='Enter Score'!$A$2
CourseTable is a Name defined for a 'table' on a
secondary worksheet called 'Course Data'. It is defined
as ='Course Data'!$A$2:$S$540
When testing in Excel 2003 the command works fine. (eg if
I set CourseName = 'Test Course' and 'Test Course' is an
entry in column A the command retrieves the correct
matching data stored in column b along the row with the
entry)
However when I transfer it to Pocket Excel I get "#N/A"
regardless of what I change CourseName too, including the
same names i use when testing in Excel 2003.
I have also tried cut and pasting test data between
worksheets to ensure accuracy in vlookup searching.
Thanks
comparison to Excel 2003?
I am trying to get the following function working under
pocket excel:
VLOOKUP(CourseName,CourseTable,2,'Course Data'!B:B)
CourseName is a Name defined for an adjacent cell ie
='Enter Score'!$A$2
CourseTable is a Name defined for a 'table' on a
secondary worksheet called 'Course Data'. It is defined
as ='Course Data'!$A$2:$S$540
When testing in Excel 2003 the command works fine. (eg if
I set CourseName = 'Test Course' and 'Test Course' is an
entry in column A the command retrieves the correct
matching data stored in column b along the row with the
entry)
However when I transfer it to Pocket Excel I get "#N/A"
regardless of what I change CourseName too, including the
same names i use when testing in Excel 2003.
I have also tried cut and pasting test data between
worksheets to ensure accuracy in vlookup searching.
Thanks