Prev: Data Validation
Next: converting db need six digit w leading zeros,
From: casdaq on 20 May 2010 18:27
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.
From: Dave Peterson on 20 May 2010 18:46
=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
 | 
Pages: 1
Prev: Data Validation
Next: converting db need six digit w leading zeros,