2 variables to create result

Hi Guys,

I am wanting to create 2 drop downs that when selected show a result dependant on the two chosen.

eg: pick a from drop down A and B from drop down 2 and it gives you result C.

I have managed to do it if I do it with

Please Login or Register  to view this content.

however I have to write each result for each query.

So I was wondering if a macro is possible to perhaps make this easier, perhaps using a system similar to PHP where each dropdown is treated as a variable.

I hope that makes sence!

Thanks, James

Could you possibly post a data sample?

So you have dropdown A1 and dropdown B1. You want to show a result based on the selection in A1 and B1.

You could use something like

=INDEX(Sheet1!C1:C100,MATCH(A1&B1,INDEX(Sheet2!A1:A100&Sheet2!B1:B100,0),0))

But to adjust the formula to your needs, I'd have to see your data structure.

cheers

Pardon?

Could you explain a bit more? The contents of Sheet1 B2 to C19 is all the same text. So why bother with a lookup or Index/Match???

Pardon?

Could you explain a bit more? The contents of Sheet1 B2 to C19 is all the same text. So why bother with a lookup or Index/Match???

If the text is all the same in your data sample, how can we test if a formula produces the correct result???