View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
casdaq casdaq is offline
external usenet poster
 
Posts: 18
Default 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.