Array Match Index

[test]

Hi,


1st, I had enrolled previously but could not remember my user name, my password, nor could I find the email sent to me with that info. So, I created a new user name in the belief I would be notified that the email address was already in use, my new registration would be stopped, and I would be provided a method to get my existing user name and password by inputting my email address. But, nope...a new user name was created, which is one I really do not want to use so...how do I get the password and user name for the initial registration I did a few months back? And, 2, if I cannot do that how do I change the username I just created to something better?


Anyway, on to my question.


Excel 2010


User inputs a # from the range of 1 - 7 in cell F3.

The #'s 1 - 7 correspond to a # in range o2-Q9, with o2-o9 corresponding to the # input in F3, p2-p9 being the description of the input #, and q2-q9 being the multiplier #


User inputs a # 1 - 3 in cell g3

The #'s 1 - 3 correspond to a # in range o12-p14, with o12-o14 corresponding to the # input in g3, and p12-p14 being the multiplier #


H3 is the multiplier # returned from q2-q9 based on the user input in f3


I3 is the multiplier # returned from p12-p14 based on the user input in g3


k3 is the result of multiplying h3 and i3 and e3


I am close..I think..by using index and match but cannot quite get it all the way. Thanks for the help.

 

[Hui]

Hi Test


Firstly, Welcome to the Chandoo.org forums.


Chandoo will have to investigate your password/username issue, I will email him


Your problem:


I'm not really sure what your asking?


Do you want the value from Column P based on the position of the value in F3 in Column O? If So a simple VLookup

=VLOOKUP(F3,O2:P9,2)

will work fine


You can then use this multiplier in the other formulas in a similar fashion, I think?

 

[test]

Thanks for the welcome & the username / passowrd help.


And, right...what am I asking for?


I want to get h3 & i3, and yes, you are correct..a simple vlookup will do that, and then I can multiply those results with a regular old multiplication formula in k3.


What I would like to do is eliminate columns h3 & i3 and go straight to k3. I thought a index-match formula could do that but I cannot seem to get it to work. So, 1 formula in k3 that multiplies e3 and a value based on 2 conditions/criteria (in h3 & i3). I hope this clarifies things.


In the meantime, I will use a vlookup...quick & dirty.


Thanks.