Excel File , received by outlook mail display right result of vlookup formula, set by sender, how its possible?

[Chirag R Raval]

Dear All,

I received an excel file though outlook mail contain normal data.
but when open it , Vlookup formula display right result even lookup file dont exist (its exist in sendr's pc)
how its possible that vlookup formula display right result?
Attached herewith screenshot for the same
please guide. on this secret...& how this situation be helpful for other aspects?
Regards,

Chirag Raval

 

[vletm]

Chirag R Raval
eg Calculation has setting as explain below:

 

[Chirag R Raval]

Dear Sir @vletm

Thank you for reply.
I try to make a file with vlookup with my another file & try to save on desktop with vlookup formula
but excel crash .each time.



i already do this



but no result.

can not guess what is the problem.

Hope there are some tweak found. (thanks in advance)

Regards,

Chirag Raval

 

[vletm]

You might have done something 'new for Excel' ...
try to do something very basic formula ... and add more feature one-by-one.

Did You tried solution 'ReStart Excel'?