Looking for a formula to return a certain number from a list

[MrJeremy]

Okay I want to do a sort of a IF statement, but not sure the exact way to do it.

I have a column full of city names, and another column with a specific list of cities

I need a formual that will return a "A" in the empty column next to the full list of cities if it the first city on the specific list, or a "B" if it is the 2nd city on the list.

Thanks in advance!

 

[NeonRedSharpie]

I don't quite understand. Can you post an example of what your data looks like now, and what you would like it to look like after the formula?

 

[MrJeremy]

Okay...here is a sample list I created...I want the Formula column to auto fill in the list based off the information on the right. Thanks!

 

[Alex0013]

Hello,

Welcome to the forums! If I understand you correctly, is this what you want?


Formula in cell B2:

=IF($D$2=A2,"A",IF($D$3=A2,"B",""))

Then you drag down this formula.

List of Cities	Value		Best Cities
Orlando			La Crosse
New York	B		New York
Chicago
Madison
San Diago
Mauston
La Crosse	A
Las Vegas
Boston
Miami

<TBODY>
</TBODY>

 

[NeonRedSharpie]

=vlookup($a2,$e:$e,2,0)

 

[MrJeremy]

Alex,

That worked, but when I tried to enter the entire list, it said to many arguments

 

[Alex0013]

Hey Jeremy,

Entire list? That should be the full formula and then you just copy that formula down to each cell below it. Unless there is more conditions you didn't mention?

Regards,
Alex