I tried to do a vlookup functin in a workbook ,the source for lookup is in
another workbook(both open).when I type
=vlookup(a6,
and then went for the other workbooks to designate the source range I do not
find the part formla in the formula bar and consequently ignoring this if I
go about the formla the formula does not work.

What could be the reason for such behaviour of the other workbook. Has the
other workbook corrupted?
thanks