VLOOKUP and IF formula

C

casdaq

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.
 
D

Dave Peterson

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

if you're using xl2007+, there's an =iferror() that you can read about in
excel's help.
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trouble with (complicated) vlookup searching another workbook 2
If equation with a VLookUp 3
IF and VLOOKUP formula combined together 3
Formula uses previous saved spreadsheet data! 4
Vlookup and if formula 2
if and vlookup formula 9
IF formula help 2
IF AND VLOOKUP formula needed 1

Top