confused,please help

[shrutikhurana]

Hi

I have a very huge excel file.....linked worksheets etc. and basicall
it uses vlookup to return numbers from the base sheets.

most of it works perfectly well except in a few rows....i have dragge
the formula all along the column , so the formula doesn't have an
error...then how come some different nos. (from the base worksheet
appear in some vlookup functions? Any ideas. Is it because of som
formatting error somewhere or...?


Thanks in advance

 

[Guest]

Hi

It would be helpful if you could post your formula. It may be the TRUE/FALSE
at the end that's missing, or maybe you need to use absolute references
rather than relative - or the other way round.
Give us a clue!!

Andy.

"shrutikhurana" <[email protected]>
wrote in message
news:[email protected]...