Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 123
  • Last Modified:

Need help with an Excel forumal or vlookup

I have an excel workbook that I need a formula for...

if column J ends with Delivery I would like K to equal Account
if column I includes any name in tab names column A then column K should equal account
else column K should equal Sales
0
Matt Pinkston
Asked:
Matt Pinkston
  • 2
1 Solution
 
nutschCommented:
Something like this, for K2?

=if(or(right(J2,8)="Delivery",isnumber(match(I2,'Names'!$A:$A,0))),"Account","Sales")
0
 
Matt PinkstonAuthor Commented:
Okay I made a mistake the field could end in Delivery or Delivery Manager
0
 
nutschCommented:
Try

=if(or(right(J2,8)="Delivery",right(J2,16)="Delivery Manager",isnumber(match(I2,'Names'!$A:$A,0))),"Account","Sales")
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now