Solved

Need help with an Excel forumal or vlookup

Posted on 2014-09-30
3
103 Views
Last Modified: 2014-09-30
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
Comment
Question by:Matt Pinkston
  • 2
3 Comments
 
LVL 39

Expert Comment

by:nutsch
Comment Utility
Something like this, for K2?

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

Author Comment

by:Matt Pinkston
Comment Utility
Okay I made a mistake the field could end in Delivery or Delivery Manager
0
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
Comment Utility
Try

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

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now