Excel Formula help

[lauriebizz]

I've got this formula, and I can't seem to find the error. Any ideas? I'm sure it's right in front of my face.
Thanks!
Laurie

=IF(iserror(VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,2,FALSE)>=VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,3,FALSE),VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,2,FALSE),VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,3,FALSE)),0,(VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,2,FALSE)>=VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,3,FALSE),VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,2,FALSE),VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,3,FALSE))

 

[SkipVought]

Laurie,

where's the termination (closing parentheses) of the iserror function?

Skip,

_[red][/red]

 

[lauriebizz]

Getting closer - still getting #N/A

=IF(ISERROR(VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,2,FALSE)>=VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,3,FALSE)),VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,2,FALSE),VLOOKUP($C262,'[LowesTemplates - 2.xls]NSPartList'!$A:$C,3,FALSE))

 

[SkipVought]

ISERROR(VLOOKUP($C262,$A:$C,2,FALSE)>=VLOOKUP($C262,$A:$C,3,FALSE))

how is an equastion and error or not.

You need to check the VLOOKUP only

Skip,

_[red][/red]

 

[lauriebizz]

OK, getting closer...
my head hurts... I'm going to think about it more...
Thanks!
Laurie

 

[SkipVought]

Each LOOKUP must be IF-tested and assigned a TRUE/FALSE result.

Skip,

_[red][/red]