Look up table?
in [Functions]
|
Prev: Reference function from an out of sort table
Next: Using Data Validation via an array to stop manual entries - possib
From: Robert_cormack on 1 Mar 2010 13:16 I am sure this is simple, but I dont know how to achieve it I have 2 drop down lists the produce values 1-3 each and a table A B C 1 500 550 600 2 450 500 550 3 400 450 500 How do I get the value at the intersection of the row/coloum, so if the drop downs come up with 1 & b the answer should be $550 Thanks
From: T. Valko on 1 Mar 2010 13:43
>I have 2 drop down lists the produce values 1-3 each >if the drop downs come up with 1 & b If both drop downs have selections of 1,2 3 then how can the drop downs "come up with 1 & b" ? Whatever the case may be, this is fairly easy to do but we'll (I'll) need some clarification. -- Biff Microsoft Excel MVP "Robert_cormack" <Robert_cormack(a)discussions.microsoft.com> wrote in message news:5289754A-8B68-42B2-BAAE-3F5A3F2EE0D5(a)microsoft.com... >I am sure this is simple, but I dont know how to achieve it > > I have 2 drop down lists the produce values 1-3 each > and a table A B C > 1 500 550 600 > 2 450 500 550 > 3 400 450 500 > > How do I get the value at the intersection of the row/coloum, so if the > drop > downs come up with 1 & b the answer should be $550 > > Thanks |