ExcelBanter - IF(ISERROR(VLOOKUP help required

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF(ISERROR(VLOOKUP help required (https://www.excelbanter.com/excel-discussion-misc-queries/451533-if-iserror-vlookup-help-required.html)

dgenty

IF(ISERROR(VLOOKUP help required

Hi I am trying to Get a IFERROR translated so it works with office 1997. I heard this can be done with IF(ISERROR but I cant get it to work.

Below is the IFERROR I am using which works fine. It does a vlookup on 2 different worksheets if it cant find the target on the first sheet.

=IF((F10=0),"",IFERROR(VLOOKUP(F10,'General Skill'!A:B,2,FALSE),VLOOKUP(F10,'Map point Exceptions'!A:H,6,FALSE)))

Claus Busch

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

All times are GMT +1. The time now is 06:57 AM.