Hidden cell formatting

[Diasorin_Stats]

I can't find a similar question, so I thought I'd post.

I am working on creating a master data sheet from data found on multiple other sheets. I am using the VLOOKUP function to fill in values specified by the Sample ID number. Most everything came over properly, except for the "Birth Date" column. Some (not all) of the cell values are coming up "#N/A", while others are transferring over properly.

My problem solving so far:

• I checked that the formatting of the Sample ID number is consistent (both Text) on both sheets.
• I checked to make sure the formatting of both columns are consistent.
• I checked the status of the TRUE / FALSE statement in the formula

Somewhat resolution:
By copying the cells that properly brought over the right information and pasting that into the location that gave the "#N/A", then manually changing the Sample ID number to fit, the correct Birth Date came across. (example: Sample ID = 001 (A2) came up with "#N/A" instead of "7/1/1995", Sample ID = 002 (A3) came up with "12/25/2001". By copying the cell of Sample ID (A3) from Sample ID = 002 into cell Sample ID = 001 (A2) and then manually overwrite cell A2 back to "001", the correct value for Sample ID = 001 (7/1/1995) would appear.

Is there some sort of underlying formatting of cells (that I can't reformulate) causing this?

Thanks,

Wes

 

[MisterProzilla]

Could you copy your VLOOKUP formula into here?