Vlookup error: Could it be Fomatting?

kswenson

New Member
Joined
Sep 28, 2006
Messages
6
Hi,
I'm working with a large amount of data. My Vlookup returns #N/A, and historically I was able to remedy this by using the F2 key in every cell. This works fine for small amounts of data, but I'm hoping there is a simpler way out there for large amounts of data.
thank you,
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

MagiCat

Board Regular
Joined
May 24, 2006
Messages
121
Andrews Utilities has a couple of routines for converting numbers to text and text to numbers as well that work pretty well.

If it's a number formatted as text, what I'll do is insert a column, use the formula =VALUE(cell), drag it down, then copy and paste it back over as a value. This will usually get things working.
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
Hi Kari
Welcome to the Board

You can use Data>Text to Columns to convert a vertical vector or a whole column text to number or number to text.

Hope this helps
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,727
Members
410,702
Latest member
clizama18
Top