Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# MS Excel - Multiple Criteria for If statement

Posted on 2016-08-17
Medium Priority
43 Views
Hi,

Column A = Forms,  I need the value to return as a "A"
Column A = Pages, return the value "B"
Column A = Headers, return the value "C"
Column A = Footers, return the value "D"
Column A = Body, return the value "E"
0
Question by:Wonderwall99

LVL 2

Accepted Solution

Martin Andrews earned 2000 total points
ID: 41759813
0

LVL 33

Expert Comment

ID: 41759818
One way is this....

In B2
``````=CHOOSE(MATCH(A2,{"Forms","Pages","Headers","Footers","Body"},0),"A","B","C","D","E")
``````

The best way is to create a lookup table and use Vlookup formula to get the desired output if there are more criteria to be compared.
1

## Featured Post

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
###### Suggested Courses
Course of the Month10 days, 14 hours left to enroll