Vlookup problem

[Zac]

I have a workbook "ABC" with P/N's listed in Col"A" all formatted as "General.
In my target workbook all the p/n's in Col "A" are formatted as GENERAL as well, and all the data associated with that P/N are on the same row.

When I use the VLOOKUP fx to grab specific data for a P/N, I get an #N/A msg.
But, when I copy the P/N from my Target workbook to ABC and paste it, I get the VLOOKUP fx to work.

I am baffled. It's not making any sense.

Can you help.

 

[texasalynn]

Re: Vlookup proble.

your table range is probably not anchored

=VLOOKUP(A1,Sheet2!A1:C100,2,FALSE)
to anchor a $ is put in like this
=VLOOKUP(A1,Sheet2!$A$1:$C$100,2,FALSE)

so that when you copy the formula down those ranges do not change

 

[Zac]

Re: Vlookup proble.

I used Absolute Addressing. Every VLOOKUP has the $$ used.

Here's another quirk.

Scenario:
12345 on my Target sheet is formatted as General.
On the sheet with the VLOOKUP fx, it too is formatted as General, but I get a error msg #N/A.
When I select the cell on the Target sheet and hit F2, then enter, the data appears.

Makes no sense to me.
If it was formatted why do you have to hit F2 for it to work????????????

 

[texasalynn]

ok I think I remember how a suggestion was made for something like that, but I would suggest that you make a copy of the sheet before doing this.

Select the area where you have had to press F2 and enter, then do a find/replace with
find is "="
replace is "="
without the quotes