possibly something to do with an if formulae

ray in maur

New Member
Joined
Oct 2, 2006
Messages
6
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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,490
Messages
5,541,028
Members
410,540
Latest member
FlaShow
Top