drop down menus

[wrpoole]

I have an excel sheet for estimating construction jobs Im trying to put all my equipment in a drop down menu (done) and in the next column have what that machine cost to use


Untitled.png

As you can see i have the drop down menu now i just need to figure out how to make the Dollar amount correspond with the machine when its selected

IE: I select a cat 336 i want the dollar amount to show up as 150

any ideas besides a mile long if and then statement?

[seasider89]

Can you post a sample workbook?

[Kyle123]

You need a lookup table and then it's simply a Vlookup formula

[wrpoole]

Thank you for the help

watched this youtube tutorial solved my issue

https://www.youtube.com/watch?v=GZX2iXfqALs

[wrpoole]

A quick question when I drag the bottom right hand corner to copy the vlookup fomula it changes the formula is there an easy way to copy past a formula

[Kyle123]

Do you mean "absolute references"?

[wrpoole]

kyle123 .... Perfect

[Kyle123]

Glad it helps

[wrpoole]

slowly making a bulletproof spread sheet

[Kyle123]

hehe as long as you don't try and make it idiot proof as well you'll do ok!

[wrpoole]

i have learned my lesson on that one plenty of times you cant fix stupid haha