Vlookup problem

[ckurka]

I've been using Vlookups successfully for a few months now. All of a sudden I'm having issues.

I use a sheet (Master Carton Dimensions) with all the information as my table array to fill out packing slips using vlookup. Recently, I am starting to not be able to copy formulas. It just returns the same data.


. I change the column #2 (Just before the FALSE argument) and I can copy this formula across rows, but when I do columns it always returns the same data all the way down.

What am I doing wrong? Could it be formatting?

This is the formula I'm using:
=VLOOKUP($A$2:$A$11,'[Master Carton Dimensions.xlsx]Sheet1'!$A:$J,2,FALSE)

[Richard Buttrey]

Hi,

Please don't upload pictures of workbooks when you have a real workbook with which we can work.

We like to see your request in context so upload the workbook and add a note explaining what result you expect and if it's not blindingly obvious how you have calculated it.

[Jonmo1]

The formula should probably be

=VLOOKUP($A2,'[Master Carton Dimensions.xlsx]Sheet1'!$A:$J,2,FALSE)

[ckurka]

Unfortunately, the workbooks contain sensitive and proprietary data.

What I expect to see is a different DCPI number, description (not shown) tarriff, pcs/ctn etc for each unique item number.

I will try to generate mock workbooks with false data so I can submit them.


Sorry

[Jonmo1]

make sure Calculation is set to Automatic

[ckurka]

Calculations are set on "Manual"

[Jonmo1]

Calculations are set on "Manual"

Ok, so what happens when you set it to Automatic?

[ckurka]

Same thing. The data is the same in all of the columns. I can't even copy simple formulas it's as if Excel doesn't recognize them. Everything has to be done manually.

[Jonmo1]

And you changed the formula to
=VLOOKUP($A2,'[Master Carton Dimensions.xlsx]Sheet1'!$A:$J,2,FALSE)
?

I think we need to see that Mocked up file..

[ckurka]

The situation seems to have been corrected. After making the change in automatic calculation, I also looked at the error checking options in the small box that appears when there is a suspect formula. I changed it from Manual to Automatic

Thank you all !

[Jonmo1]

You're welcome.