Reference info from multiple tables

Question

Using data validation, I select 1 of 5 tables to get information on an item, but i cannot figure out how to get the rest of the information in the row in the selected table. H4 has the dropdown and B39 has the data validation, how do i get the rest of the info to populate?

detlef_lewin · Answer

Scott,
&nbsp;
I used some helper cells at C55:D60:

1
&nbsp;

Paving
Table_Paving_1

Iowa
Table_Iowa

Nebraska
Table_Nebraska

NonDOT
Table_NonDOT

Rebar
Table_Rebar

&nbsp;
&nbsp;

C55
=MATCH(H4,$C$56:$C$60,0)

E39
=VLOOKUP(B39,CHOOSE($C$55,Table_Paving_1[#All],Table_Iowa[#All],Table_Nebraska[#All],Table_NonDOT[#All],Table_Rebar[#All]),3,FALSE)

F39
=VLOOKUP(B39,CHOOSE($C$55,Table_Paving_1[#All],Table_Iowa[#All],Table_Nebraska[#All],Table_NonDOT[#All],Table_Rebar[#All]),4,FALSE)

&nbsp;
&nbsp;

Forum Discussion

Reference info from multiple tables

Share

Resources

1
Paving	Table_Paving_1
Iowa	Table_Iowa
Nebraska	Table_Nebraska
NonDOT	Table_NonDOT
Rebar	Table_Rebar

C55	=MATCH(H4,$C$56:$C$60,0)
E39	=VLOOKUP(B39,CHOOSE($C$55,Table_Paving_1[#All],Table_Iowa[#All],Table_Nebraska[#All],Table_NonDOT[#All],Table_Rebar[#All]),3,FALSE)
F39	=VLOOKUP(B39,CHOOSE($C$55,Table_Paving_1[#All],Table_Iowa[#All],Table_Nebraska[#All],Table_NonDOT[#All],Table_Rebar[#All]),4,FALSE)