referencing data in cell


Posted by itgirl168 on February 08, 2002 11:50 AM

help please!
i have 3 columns

column a column b column c
1 john
2 mary
3 joe


i want column c to pull data based on column a and column b. for instance. if b:b equals 'john' then i want column c1 to equal the corresponding cell in column a
so in my example, c1 will equal whatever value is in a1
hope this is clear

thanks!

Posted by Aladin Akyurek on February 08, 2002 11:59 AM


In C1 enter: =INDEX(A:A,MATCH("John",B:B,0))

==================

Posted by JohnG on February 08, 2002 12:02 PM

Is this the sort of thing you want?
Cell C1=
=IF($B1="John",$A1,"")



Posted by itgirl168 on February 08, 2002 1:33 PM