VLookUp Help

[bdunk]

Hello, I am trying to do a VLookup between two sheets. After formatting the columns to Text and writing the following:

=VLOOKUP(B2,'Top Down.xls'!$D$5:$E$62,2,FALSE)

I get the #N/A error.

To get this to work I can click in the cell of the lookup column of my table array. Place the cursor at the end of the number and press enter and the VLookup then works.

Any reason why this does this and what I can do to not have to click in every cell and press enter?

Thanks

 

[jmthompson]

Because formatting the columns does not format the cells if they are already populated.

There is a shortcut to convert all to text, but I forget and will have to search the board

 

[tshooter]

In tools - option - calculation

if it is manual change it to automatic.

 

[bdunk]

NO it is set to Automatic.

Brian

 

[bdunk]

Anyone else have any thoughts on this?