Hi

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

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


Thanks in advance.


--
shrutikhurana
------------------------------------------------------------------------
shrutikhurana's Profile: http://www.excelforum.com/member.php...o&userid=29868
View this thread: http://www.excelforum.com/showthread...hreadid=508071

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"
wrote in message
news:shrutikhurana.22nk6n_1138968601.7847@excelfor um-nospam.com...

Hi

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

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


Thanks in advance.


--
shrutikhurana
------------------------------------------------------------------------
shrutikhurana's Profile:
http://www.excelforum.com/member.php...o&userid=29868
View this thread: http://www.excelforum.com/showthread...hreadid=508071