Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Need help with an Excel forumal or vlookup

Posted on 2014-09-30
Medium Priority
117 Views
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
Question by:Matt Pinkston
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 39

Expert Comment

ID: 40352841
Something like this, for K2?

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

Author Comment

ID: 40352884
Okay I made a mistake the field could end in Delivery or Delivery Manager
0

LVL 39

Accepted Solution

nutsch earned 2000 total points
ID: 40352898
Try

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

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
###### Suggested Courses
Course of the Month7 days, left to enroll