Need a funtion that will retern a numerical value based on a drop down list.

[jnwc82]

If this sounds impossible or crazy, just tell me.
I need help with a formula.
What I am trying to do is have a drop down list in one cell and have the next cell bring in the correct price for the item in the first cell. Sounds fairly easy? Well both lists are 200 items.
I have been trying to do this with just three items so far. On sheet two, I have created two lists. The first list in column A contains dogs, cats, mice. The second list in column B contains 1, 2, 3. On sheet one, I have created the drop down list for the animals in the A12 cell. I would like for B12 to auto populate the corresponding number to the animal without having to create an if formula for each animal and number.
Any help with this issue would be greatly appreciated!

[cbatrody]

Hi,

Welcome to the Forum.

You can do this with the help of VLOOKUP function. Enter the following formula in B12 Sheet1.

=VLOOKUP(A12,Sheet2!A:B,2,0)

Please see the attached file.

[jnwc82]

Thank you! Thank you! Thank you!
You have no idea how much this helps!
Thank you again!

[cbatrody]

You are welcome

Also, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful.

[jnwc82]

Done! And thank you again! You saved my hair. lol