IFNUMBER works but not IFFORMULA for VLOOKUP

[eli_m]

Hi,

I have two formulas:

This one works:
=IF(ISNUMBER(VLOOKUP('Pivot Tables'!A17,'IPS Cases'!A$1:AQ$200,16,FALSE)),"Y","N")

and this one that doesn't:
=IF(ISFORMULA(VLOOKUP('Pivot Tables'!A17,'IPS Cases'!A$1:AQ$200,16,FALSE)),"Y","N")
as I get this error:

is there a way I can check if a cell is a formula using VLOOKUP?

Thanks in advance

 

[Phuoc]

Use INDEX +MATCH:

=IF(ISFORMULA(INDEX('IPS Cases'!P$1:P$200,MATCH('Pivot Tables'!A17,'IPS Cases'!A$1:A$200,0))),"Y","N")