Vlookup / Index (match)

[profector]

Little problem here with a #N/A error. I have a worksheet with data that was dumped out of a database and another worksheet with a list of hand typed number. I am trying to lookup the hand typed numbers in the worksheet that was dumped from the database. The formulas seem with be correct (below). I think it's because the data types aren't the same becuase if I find the match number in the data worksheet and free type it in the correct data is returned. Any ideas?

Here's another thing I noticed. If I click in the cell and hit <enter> the alignment changes from left to right and the formula returns the correct value.

=INDEX(Data!$E$2:$E$53000,MATCH(A30,Data$A$2:$A$53000,0))

or

=VLOOKUP(A125,Data!$A$2:$E$53000,5,FALSE)

[NBVC]

It seems column A is formatted as text...Try selecting column A of the Data sheet and then go to Data|Text to Columns and simply click Finish...

[profector]

Thanks that did the trick.