Forum Discussion
Reference info from multiple tables
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 B...
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) |