How to perform a VLookup inside of a Protected Worksheet?

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?

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.