Removing hidden Format,formula preventing V-lookup from pulling data

[Von Man]

I have a spreadsheet with data from multiple sources I am trying to
pull data in via V-Lookup, but on two of the three spreadsheets it
pulls only about half of the data.

The pull is based on numbers, but Ive tried adding a letter to the
data but it still doesnt not recognize those cells and returns #N/A.

Any ideas?

 

[BRO]

I am not sure i fully understand your case, however, i have two
comments on the limitations of the Vloopup function that might help
you.

1st: while using the vlookup function, the cell u r trying to look for
(lookup value) should be in the 1st column (to left) in the "Table
array"
Otherwise, it will return #N/A

2nd: the vloopup function just does not return the value Zero (thus,
it does not keep the cell empty) it rather displays #N/A

try the ISNA combined with an If statament

=If(ISNA(vlookup(A1,B1:C10,2,false)),"",vlookup(A1,B1:C10,2,false))

Hope it was helpful

 

[Shane Devenshire]

To Unknown - same comment as previously - put the question in the body of the
email.

To BRO -
Just to clarify: If a lookup table contains a match on the item but there
is an empty cell in the return column or a zero it returns zero (0). Since
your first point says that if the item is not found it returns NA (assuming
an exact match) this second point is either redundant or incorrect.