IF(ISERROR)

Hi All,

Trying to figure out how to use IF(ISERROR) function with the following formula.

IF(C57=$C$14,VLOOKUP(C57,'Travel Reference'!$A$1:$B$42,2,FALSE)*(B57+1),VLOOKUP(C57,'Travel Reference'!$A$3:$B$42,2,0))

I can attach workbook if need be. I'm currently trying to have an automatic formula populate once workbook users fill out the input section. I'd like to have the calculation and result cells locked. My problem is that if the users haven't selected any inputs it will produce #N/A until the users select inputs for that line. I would like to figure out how to have it so it will not be #N/A if input lines are blank. My best bet is IF(ISERROR), I've got it working with other formulas, but can't figure this one.

Can anyone help?

Thank you!!

Nick's picture

try this: (for Excel 2007

try this: (for Excel 2007 and above)

=IF(C57=$C$14,iferror(VLOOKUP(C57,'Travel Reference'!$A$1:$B$42,2,FALSE)*(B57+1),"XXX"),iferror(VLOOKUP(C57,'Travel Reference'!$A$3:$B$42,2,0),"YYY"))