Hi all,

The below formula is working on about 40% of the sheet i'm using it on - for the rest the result is 'False'. Can someone explain why it's only partly working?

=IF(B18='Receipted qty'!A18,IF('bill qty'!C18='Receipted qty'!C18,VLOOKUP(B:B,'Receipted qty'!A:D,4,0)))

I've manually checked the results and it should be bringing back a number (like the rest did), as the answer is within it's boundaries.

Bizarrely i'd understand if it did not work at all (got formula wrong), but only half working has thrown me

Any help would be greatly appreciated.

Cheers.