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
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

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.
 

Forum statistics

Threads
1,141,151
Messages
5,704,586
Members
421,358
Latest member
Redstar13

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top