Thread: Multiple Drop-Downs used as parameters for VLOOKUP

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

Thanks for the replies!

I got it working, NBVC's formula worked for me, The Indirect in the first variable was messing my formula up,

Thanks again,

Josh