Formula fill error

**Cat22** · 09-18-2008, 10:39 AM

I created a spreadsheet with alot of data spread over several worksheets, and using several formulas. Many of my formulas pull data from one worksheet to another. (using VLOOKUP) however when it came to testing this i found that several cell failed to pull in data, despite them having the same formula asthe cells above and below them! The data is definately in the other sheets waiting to be found!! Why is this?!!?
Could it be because i'm using too much of the memory up? Because when i deletetheformula and re-typeit - exactly the same as it was, except omitting the $, it works!!

What do i do??

**NBVC** · 09-18-2008, 10:42 AM

First check that you are in Automatic calculation Mode... go to Tools|Options and in the Calculation tab, the Automatic should be checked.

**Cat22** · 09-18-2008, 10:56 AM

Tried that but it didn't sort it!!

**NBVC** · 09-18-2008, 11:03 AM

Does your Vlookup() formula have a 4th argument of FALSE or 0... to find exact matches?

**Cat22** · 09-18-2008, 11:17 AM

yes it has a FALSE
it reads ...
=IF(ISNA(VLOOKUP(A12,HOURS!$A$54:$AG$304,21,FALSE)),"",VLOOKUP(A12,HOURS!$A$54:$AG$304,21,FALSE))

andworks for A11 and A13 andthoseaboveand belowthat!!

**NBVC** · 09-18-2008, 11:32 AM

Possibly you have extra spaces in A12 or in the "Matching" Hours!A54:A304 range?

Or if the data is numerical... is A12 and it's "matching" item both formatted the same?