1

I am having problems using the VLOOKUP function with a SharePoint Excel export file.

I have managed to get successful results for 2 of the lookups, but unless the columns in the owssvr sheet are side by side, and the first column is referencing the lookup cell, it doesn't work. For example:

The owssvr sheet has 4 columns. The reference cell is in column B [Project Title]. This formula works and returns the value for 'Project No.':

=VLOOKUP($C$5,Table_owssvr[[Project Title]:[Project No.]],2,FALSE)

... but this one doesn't:

=VLOOKUP($C$5,Table_owssvr[[Project Status]:[Project Title]],1,FALSE)

Do you know why this is happening and how I can resolve it? Also, do you know if it is possible to have more than 2 columns in the array?

Many thanks! Tina.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.