IF(ISERROR(VLOOKUP help required
Hi,
Am Wed, 6 Jul 2016 14:38:28 +0100 schrieb dgenty:
=IF((F10=0),"",IFERROR(VLOOKUP(F10,'General
Skill'!A:B,2,FALSE),VLOOKUP(F10,'Map point Exceptions'!A:H,6,FALSE)))
try:
=IF(F10="","",IF(ISERROR(VLOOKUP(F10,'General Skill'!A:B,2,0)),VLOOKUP(F10,'Map point Exceptions'!A:H,6,0),VLOOKUP(F10,'General Skill'!A:B,2,0)))
Regards
Claus B.
--
Windows10
Office 2016
|