The below formula will do

In C1
=IF(A1<B1,"a",IF(A1=B1,"c","b"))

Further to handle blank entries
=IF(COUNT(A1:B1),IF(A1<B1,"a",IF(A1=B1,"c","b"))," ")

If this post helps click Yes
---------------
Jacob Skaria


"sam" wrote:

I have an excel sheet where I want to auto populate a field (that has
specific values listed in a drop down menu) based on two other fields (both
are dropdown menus with specific values)

For Eg.:
there are 3 fields A, B, C and all these three fields have specific values
which we can select through a drop down menu. Now, Lets say values in the
fields are as follows:

A: 1, 2, 3, 4, 5
B: 1, 2, 3, 4, 5
C: a, b, c

So now, If I select '1' for A and '1' for B then I DONT want any thing to
populate in C and leave it blank.
If I select '1' for A and '2' for B then I want 'a' to be populated in C
If I select '2' for A and '1' for B then I want 'b' to be populated in C
If I select '1' for A and '1' for B then I want 'c' to be populated in C

Basically,
If the value in field A is smaller then field B then I want 'a' to be
populated in C.
If the value in field B is smaller then field A then I want 'b' to be
populated in C.
If the value in field A and B are equal then I want 'c' to be populated in C.

Hope I made it clear enough.

Thanks in Advance.