“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=IF(ISERROR(VLOOKUP(B9,$M$2:$M$10000, 1, FALSE)),FALSE,TRUE )

Solved by A. H. in 14 mins

Hello. I am having issues with the ISERROR function

Solved by B. A. in 16 mins

=IF(ISERROR(VLOOKUP($C28,Agripharm!$T$1:$AT$11,MATCH(Summary!G$5,Agripharm!$T$1:$AT$1,0),0)),0,VLOOKUP($C28,Agripharm!$T$1:$AT$11,MATCH(Summary!G$5,Agripharm!$T$1:$AT$1,0),0))

Solved by D. U. in 16 mins

I want to understand this formula and see where the source data is coming from =IF(ISERROR(VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),3,0)-VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),2,0)),0,VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),3,0)-VLOOKUP($A6,INDIRECT("'"&O$1&"'!q:s"),2,0))

Solved by S. A. in 19 mins

i have table that contain data i want to do a vlookup or any formula to like> =IF(ISERROR(VLOOKUP(B5,A5,'In Put Data'!B:E,4,FLASE)),0,VLOOKUP(B5,A5,'In Put Data'!B:E,4,FALSE)) but it is not working is there any solution

Solved by Z. L. in 14 mins