Results 1 to 2 of 2

Thread: How to perform a VLookup inside of a Protected Worksheet?

  1. #1
    Neophyte Echo416's Avatar
    Join Date
    Nov 2020
    Posts
    2
    Articles
    0
    Excel Version
    2016

    How to perform a VLookup inside of a Protected Worksheet?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello, I am in the need of pulling information into cells that reside inside of a protected worksheet. It seems that the protection is based on the "INVALID VALUE" (The value entered must be a decimal number).

    If there a way around this?

  2. #2
    Seeker RET's Avatar
    Join Date
    Nov 2020
    Location
    Spain
    Posts
    12
    Articles
    0
    Excel Version
    2019
    Which information are you puling? If it is not thw alloed data type, you should unprotect the sheet. If not, try to pull information to a new spreadsheet.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •