Hello,
I am making a spreadsheet as follows:
I have a drop-down for State and another for Company and I would like Excel to check the Company Data for the State Listed and return a Value in the Second Column.
My data is set up grouped by Company and each state has an entry under each company in column one and in Column 2 are numerical Values for that company in that state. ie Named Group Vorizon, Column 1 =States, Column 2 = Numerical Values
I would like the VLOOKUP to Check the Drop-Down box for State for the Value to Look up, Check the 2nd Drop-Down box for Company for the matrix or table to look the value up in, and I would like it to return the value in column 2 of the company table or matrix.
I tried this: =VLOOKUP(INDIRECT(B2),INDIRECT(D2),2,FALSE)
B2 is the drop-down box for State and D2 is the drop-down box for Company
but it does not work,
Any Suggestions?
Thanks,
Josh
Bookmarks