MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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=

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