IF statement...

**axc0054** · 09-15-2008, 05:18 PM

I have a colum where the listings may contain "A", "B" , "C", or "D". No numeric characters...well from there I want to state that if

A1="A" then output is "Joe"
A1="B" then ouput is "Joe"
A1="C" then output is "Jane"
A1="D" then output is "Dave"

I was sure pretty sure that the statement was an IF function and may contain an ELSEIF but I can not seem a source to show me if I am right or wrong, nor can I produce the outcome. Could some please point me in the right direction?

This is what I came up with

=IF((AND(T2="PC", T2="MP", T2="AC", T2=FC)),"VSD","VSV")

**VBA Noob** · 09-15-2008, 05:23 PM

For your example try

=IF(A1="","",LOOKUP(A1,{"A","B","C","D"},{"Joe","Joe","Jane","Dave"}))

or set up a table and use vlookup if you have a lot of conditions

VBA Noob

**sglife** · 09-16-2008, 02:13 AM

For the sample you gave, the following IF formula can make it too

Please Login or Register  to view this content.

**axc0054** · 09-16-2008, 12:59 PM

Thank you! I used Sglife's for now, make sense for what I am doing now. I only have nine variables to consolidate into two categories. Though at some point in time I will have to make a table.