VLOOK Formula Only Shows the VLOOK Formula Instead of Lookup Value

Hello,

I have entered a VLOOKUP formula to populate cell B2 on worksheets 1 through .60 in the workbook. The formula returns the values from the MasterList sheet on all of the worksheets except worksheets named 2 through 12. I've entered the same formula on all of the sheets but cannot figure out why the lookup value will not return the information on these sheets. The formula I used is:

=VLOOKUP($A$1,MasterList!$A$1:$b$60,2,0)

Can some please take a look at the attached workbook and let me know what I am doing wrong? Thanks.

Looks like you've got those cell formatted as "Text;" change them to "General."

Also, looks like you're going to have to change the value of your references in A1 to text in order to get the lookups to work; I don't think VLOOKUP likes looking at formulas.

It's odd. If I just press F2, highlight formula and then Ctrl-C hen Ctrl-V it comes up as a formula
Try evaluate formula before and it says "This cell contains a constant"

Originally Posted by Mvaldesi

Looks like you've got those cell formatted as "Text;" change them to "General."

Originally Posted by Mvaldesi

Also, looks like you're going to have to change the value of your references in A1 to text in order to get the lookups to work; I don't think VLOOKUP likes looking at formulas.

Lastly, you're going to have to convert the first few references on your MasterList tab to text by putting an apostrophe in front of the first digit.

Wow...all of the advice worked like a charm. Thank you all so much. I have been racking my brain as I am fairly new and self taught with excel formulas but I am always trying to learn different things to make life a little easier. Love this site!!!

You're wel... oh, he's gone.