Reference info from multiple tables

[Scott Belyea]

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?

[#2]

Scott,

I used some helper cells at C55:D60:

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)