Google Sheets

[rydods]

Any google sheets/excel experts out there that can help with an issue?

I'm trying to create a price calculator sheet. I want to have a dropdown list of items. I want each item to have a square foot price somehow "tied" or linked to it so when I put in the quantity, height, length I get a total. I can get more elaborate than this but it's the "each item in the list" having a square footage price formula I can't figure out. I've googled but everything seems to go over my head. I hope this makes sense.

Attached is a basic screenshot if that helps. You can PM me if you'd like as well. Thanks

 

[SignMeUpGraphics]

Sounds like you need to read up on VLOOKUP.

 

[ColorCrest]

You should be able to make something of the following, although it's not exactly Google Sheets...

 

[Pauly]

This can get complex.

I believe excel is more powerful than google sheets though.

You need to learn about VLOOKUP.

You'd need to create a seperate page for "Data" and have your stock list there and formulas.
have a dropdown box with vlookup.

Some youtube videos and some hours later you could get there.

 

[ColorCrest]

I can get more elaborate than this but it's the "each item in the list" having a square footage price formula I can't figure out.

Further...

 

[rydods]

Thanks! Sorry, I wasn't very clear...By the formula I meant what gets each item on the drop down list to have a separate "google sheets formula or number" so that each item is different, not just the cell itself. From most of the posts, it seems that VLOOKUP is what I need to research. Thanks again!

 

[Christian @ 2CT Media]

Here is a quick example for you: https://docs.google.com/spreadsheets/d/1UrFsLH3KAEnvAFDZMvi7DylNO1ddSxRyKrWJmLpm7Sw/edit?usp=sharing

 

[Pauly]

Here is a quick example for you: https://docs.google.com/spreadsheets/d/1UrFsLH3KAEnvAFDZMvi7DylNO1ddSxRyKrWJmLpm7Sw/edit?usp=sharing

doesn't google docs do dropdowns?

In my spreadsheet, i have dropdowns of the stock, and vlookup gets the stock name and inputs a price in another cell. Easier than always writing the name.

 

[Christian @ 2CT Media]

Yes, this has data validation on it with dropdowns, I expanded the field area. The reason why I said quick, is I can also show how to use a "Add new Line" Macro to make it more interactive and form-like.

I just updated the sheet with a few clean-ups, but at least this will give the OP a start point of code to get where he/she is going.

 

[Christian @ 2CT Media]

In excel you can use xLookup which is awesome and intuitive enough to search in any direction.

 

[rydods]

Here is a quick example for you: https://docs.google.com/spreadsheets/d/1UrFsLH3KAEnvAFDZMvi7DylNO1ddSxRyKrWJmLpm7Sw/edit?usp=sharing

Thank you! This is very helpful. I did a lot of research on the "VLOOKUP" formula yesterday and am definitely moving in the right direction. Your spreadsheet will definitely help me further. Thanks again!

 

[Christian @ 2CT Media]

No

Thank you! This is very helpful. I did a lot of research on the "VLOOKUP" formula yesterday and am definitely moving in the right direction. Your spreadsheet will definitely help me further. Thanks again!

No problem at all. I like numbers and software so these are things I enjoy figuring out anyway. If you have any other questions, Hollar.