View Single Post
  #1   Report Post  
dgenty dgenty is offline
Junior Member
 
Posts: 2
Default 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)))