Baffled with autofilter

[Sahil123]

Hi guys,

I have a normal formula like this to match data. =MATCH(E2,'INDEX SHEET'!$G$4:$G$38,0). When i evaluate the formula by highlighting the whole formula and press F9, the formula gives me the right answer but when i enter the formula and autofilter down, i don't the correct answer. It pulls through the same result as in my starting cell. If i go into each cell and press enter, it works

Weird and baffled

 

[VoG]

Tools > Options, Calculation tab. Make sure calculation is set to Automatic.

 

[Sahil123]

Tools > Options, Calculation tab. Make sure calculation is set to Automatic.

Thanks

That works Fabulous

Really appreciate it

P.s Why did that stop the autofilter from working correctly?