possibly something to do with an if formulae

[ray in maur]

I know some of you real good at this but I just cant get this right and I really need help
I am trying to do a formulae on excel eg 1 = completed 2 =not done etc
column A has
compeleted
not done
in process of doing
and colomn B has
1
2
3
1
Etc
and column C also has
3
2
1
Ect now I want to do if C= 1 look in column B for 1 and take the information from column A.
please tell me some one can do this it would be great

 

[RalphA]

The Excel function VLOOKUP() might be what you are looking for. It works by looking in the leftmost column in a specified range for a known value, then returning the value in a specified column, on the same row as the data is.

Two requierments:
1. The leftmost column of the range must be sorted in ascending order!
2. The leftmost column must be the reference column.

From the requierments, the reference column cannot be 1, 2, 3, 1, etc., since it must be sorted in ascending value. But, as long as you use only the three-row range, it chould be made to work,with a good, more complete sample of your data.