VLOOKUP and IF formula
 

I have this formula already in use...

=VLOOKUP(B17,'[DSL UVERSE CLOSE RATES - APR
10.xlsx]Pivot'!$A$2:$C$291,2,FALSE)

I need it to include an "If" formula as well returning a "-" dash if it
cannot find the name on b17 in the file it's looking up.

Any help is appreciated.

VLOOKUP and IF formula
 

=if(isna(vlookup(b17, ...)),"-",vlookup(b17, ...))

if you're using xl2007+, there's an =iferror() that you can read about in
excel's help.

casdaq wrote:

I have this formula already in use...

=VLOOKUP(B17,'[DSL UVERSE CLOSE RATES - APR
10.xlsx]Pivot'!$A$2:$C$291,2,FALSE)

I need it to include an "If" formula as well returning a "-" dash if it
cannot find the name on b17 in the file it's looking up.

Any help is appreciated.

--

Dave Peterson