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

EXCEL - IF(IFERROR(VLOOKUP question 0
Formula uses previous saved spreadsheet data! 4
IF and VLOOKUP formula combined together 4
Vlookup Different tabs based on Dates 5
Vlookup and if formula 2
IF AND VLOOKUP formula needed 1
Vlookup across 3 worksheets 2
vlookup or index/match formula?? 2

Top