Share via

VLOOKUP FORMULA WITH UNKNOWN TABLE ARRAY!!!

Anonymous
2013-07-25T08:43:23+00:00

hi !

I'm feeling very frustrated! In a file excel that I have received I have this formula:

=VLOOKUP(B14,'Language Tools'!A:F,Country_Code+1,0)

the problem is that I don't find the table array 'Language Tools'!A:Fbecause write in this way it should be a sheet within the file! and there isn't unhide sheet in the file!

there is only one sheet in the file protected by a psw but I don t think it depends on it

I m going crazy! please help me to find a way to find this sheet

thanks

Emilio

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2013-07-25T12:33:18+00:00

    it is flag "protect structure and windows" in protect workbook

    and the password it s different from the one used for unprotected the sheets :/

    thanks I have to find this psw :)

    Was this answer helpful?

    0 comments No comments