Populate Data Based On Changing Criteria

[kumara_faith]

Hi,

I have the following in one table:

Excel Workbook
	B	C	D
2	Branch Name	Dallas	Austin
3	State	Texas	Texas
4	Address	K Street	J Street
5	Life Tel No1	323224234	123123123
Sheet6

In another table, I have a dron down menu in cell C10. When I choose the branch in cell C10, I need the data to populate accordingly based on that branch in cell C11 to C13.

Excel Workbook
	B	C
10	Branch Name	Dallas
11	State	*
12	Address	*
13	Life Tel No1	*
Sheet6

Appreciate help.

 

[BenMiller]

In C11:

=INDEX(3:3,MATCH(C$10,$2:$2,1))

and drag down to C12 and C13.

 

[kumara_faith]

Hi,

The formula does not seems to work as it is returning the data for Austin branch regardless of the value in C10. In addition, I am referencing table 1 from another worksheet. Please help.

 

[kumara_faith]

Hi,

I have a cross post here:

Populate Data Based On Changing Criteria

 

[BenMiller]

So change the 3:3 in the formula to reference the worksheet/row you're pulling from. For example, =INDEX('Best Worksheet Ever!'8:8,(MATCH( etc.

 

[kumara_faith]

Thank you for your solution Ben.